c;0??ACGKOSSSSSW[_cٰz_#` @`@ 0n exn 5x6x6xr tr l p n Hmaster.mdfcw (gl (* Zw`YwMcwj w wi (* (j ( "*j RC,j RCpl wȰwl l Xw Zw`YwYw C:\TEMP\modellog.ldf(*  \l yw3 8l < w0wl Lw 3 l Em w w l @l 03 3 4Dp IK  .ldfog"ww4P` 0O0zq x@@@n exn 5x6x6xr tr l p n Hmaster@.mdfcw (gl (* Zw`YwMcwj w wi (* (j ( "*j RC,j RCpl wȰwl l Xw Zw`YwYw @C:\TEMP\modellog.ldf@(*  \l yw3 8l < w0wl Lw 3 l Em w w l @l 03 3 4Dp IK  H.ldfog"ww4PR#$HY1syscolumnsD 7`D c7pL  8ZL .,cL&@r0R&|^rsyscolumns m8 F0*S c1 Fsyscolumnsp 70&7name4 ca`l @ 30&88 3idt  90&009xtypex?0&00 ?typestat|A0&44 Axusertypet;0&44@  ;lengtht90&00 9xprect;0&00 ;xscalet90&44  9colidx =0&44  =xoffset@t ;0&00  ;bitposx ?0&00  ?reservedx =0&44  =colstatx ?0&88 ?cdefaultt@;0&88 ;domaint;0&44 ;numberx?0&44" ?colorderx=0&@=autovalt;0&44@$";offsetp70&7namel30&88 3idt  90&9xtypep!!50&44  5uidp"@"70&44 7infot##;0&88 ;status$$M0&88 Mbase_schema_verx%%?0&88 ?replinfo|&&@C0&88  Cparent_objt'';0&== ;crdatex((=0&44 ( &=ftcatidl))30&88 3idt**;0&88 @;statust+ +90&  9firstt,!,90&449indidp-"-70&7roott.#.;0&44;minlent/@$/;0&44;keycntx0%0=0&44=groupidt1&1;0&88 ;dpagesx2'2?0&88 $ "?reservedp3(370&88@ ( &7usedt4)4;0& , *;rowcnt|5*5A0&88 4 2Arowmodctrp6+670&00867soidp7,770&00977csidx@8-8=0&44:8=xmaxlenx9.9=0&44<:=maxirow:/:K0&00><KOrigFillFactor;0;E0&00?=EStatVersion|<@1<A0&88 @>Areserved2x=2=?0&DB?FirstIAMt>3>90&44JH9impid|?4?A0&44LJAlockflagsx@5@?0&88 NL?pgmodctrpA6A70&07keyspB7B70&7namexC8C?0&""?statblobtD9D90&b88 @9objidtE:E90&b449indidtF;F;0&b44 ;fileidG<GE0&b88   EgamintervalxH=H=0&b=iampaget@I>I;0&88 ;statustJ?J;0&44;fileid4K c bapL@K70& 7namexMAM?0& ?filenamePHN BBPO OPP P4c1m8v""L"!!! l ,LXlpt,DXp8LX\ |  , @ T h x0@TD4`@P $$*H01syscolumns *@*m8XXHSB @   88 44 44  @R&|^rscolumns @ @&B|88 44 44@ @syscolumns@0R&BB|^rsyscolumnsm8"X807d7m8v^bm88m8^b0m8fb8m8,00//|m8|m8Hbm800@/3/0hm8ffj00,0/tm8cb/X00,00/m80,00m8)b,00d10m8jc,00tm8Cm8@0$7m8m8Yvm8́C,00m8/*F .28m8D IND syscolumn S 8m8vDm8hh)  hm8uv m8ptm8pm8m8 @ S D* L7`D* c*7pL*  8ZL* *.,*H@c8**D*  *7`L*  *48* * D H`  P#3,* *L3 .D3 * b"8 c!>x<>x<@BB@ !,7BMXcny)4?JU`kv&1<GR]hs~@bbbbb33TT@t e33  WẀL3  3D3 3P3 3P3! H3!4*1*<|8L p < tp$t0ht0P DsP3<D1systypesD< 37"`D< c<70pL<  8ZL< <.,<cL<8<@3"n0R,^nsystypes <m8|< 3B0*S  1 Bsystypesp< 9* 70&7namet< :< 90&00@9xtypet< ;< ;0&00;status|< << A0&44Axusertypet<=<;0&44;lengtht<><90&00 9xprect<@?<;0&00  ;xscalex<@<?0&88   ?tdefaultt<A<;0&88  ;domainp<B<50&44  5uidx<C<?0&@44  ?reservedd<<,0@ ,binary4< c<a``<<&0hh &bit`<<(0@ (charh<<00== 0datetimeh@<<.0jj&& .decimald<<*0>>5 *floatd<<*0"" *image`<<&088  &intd<<*0<< *moneyd<@ <*0@ *nchard<  < *0cc *ntexth<! <!00@ 0nvarcharh<" <".0ll&& .numeric`<# <#(0;; (realt<$@<$:0:: :smalldatetimeh<%<%0044 0smallintl<&<&40zz  4smallmoney`<'<'(0## (textl<(<(20 2timestamph@<)<).000 .tinyintl<*<*20@ 2varbinaryh<+<+.0@ .varcharx<,<,@0$$ @uniqueidentifierh<-<-.0H.sysnameP<. <P</ </ P<0 <0P<1 <14<1<Xh8d0\ T , d 4 <Th 8|0\ P FD0:1systypes F@Fm8XXHS @     R@,^nstypesns @ @,@@systypes@0R,^nsystypesm8"X807d 7m8v^bm88m8^b0m8fb8m8,00//|m8|m8Hbm800/`2/0hm8ffj00,0/tm8cb/X00,00/m80,00m8)b,00d10m8jc,00tm8Cm8@0$7m8m8Yvm8́C,00m8/*B .28m8D IND systypes S 8m8vDm8hhnt NOT LL, stus tinyint N  hm8uv m8ptm8pm8m8t NOT NULL, length smallint NOT NULL, @ xprec tinyint NOT NULL, xscale tinyint NOT NULLS  DF <!7`DF cF"7pLF  8ZLF F.,FH@c8FFDF  F#7`LF  F48F F @D|\ P O,F FLO <.DO F a!8 c3!v88 sysobjects \ 0 0 @ -------------------- -- Add calog NC-inxes --------------------- CRTE UNIQUE NCLUSTEREDNDEX ncsysjects N sysobjec ( tm8pm8m8d ) @ S  DU O7!`DU cU70pLU  8ZLU U.,U@c8UU,U UPU O$ PU U ( U U 0R44 88 ncsysob@ectsU U 0R44 88 ncsysobjectsUU0R44 88 ncsysobjectsH@UO UU1*>*>*>*>A'Fc0'sysallocations0syscolumns0sysfiles10sysindexes0sysobjects0systype@UUTT eUU  WWЀPUU4 LUO UDUH UPU UPU U4U1U0`D tHLdsj PbP 0 1ncsysobjects2 b @b m8XXHS    88 88  @ @   88 88 @@ncsysobjects2@0R*>v88 sysobjectsd/0,00/m8cb/m8m8$[7m8@0m8)b,08m808m8jc,07m87ZftK$g7d0"bd7m8m8Yvt,0tm8m8`\00@  sysobjects CREE NONCLUSTED INDEX nysobjects2 ON sysjects ( pant_obj ) ---- CRTENIQUE NCSTEREDND ncsysjes N sobjec (tm8pm8m8d ) @ S  Db U%7`Db cb&7pLb " 8Z!Lb "b.!,b @"c8b b!,b bPb  U$ Pb  b ( b  b 0R!!  "88 88 ncsysobjects2@  b 0R!!  "88 88 ncsysobjects2b b0R!!  "88 88 ncsysobjects2Hb U@Db b 1?*>A !,7b bTT  eb bH  WWPb b4 DU b Pb  b4b  1bTPDxLP hb PhnL 0f 1ncsyscolumns n @n m8XXHSM    88 44  @ @  88 44@ 88 44 44 @ncsyscolumns@0R@&M |̀88 44 44 syscolumnsm8m8$[7m8@0m8)b,08m808m8jc,07m87ZftK$g7d0"bd7m8m8Yvt,0tm8m8l\`0`0!!  " @ sysobjectssybjects CREE UNIQUE NCLUSTERED DEX ncsyscumns syscolumn( id, namenumber ) TENIQUE NCSTEREDND ncsysjes N sobjec (tm8pm8m8d ) @ S Dn b'7`Dn cn(7pLn $ 8Z#Ln $n.#,n @$c8n n#,n nPn  b$ Pn  n ( @n  n 0R## M$88 44 88 @44 44 ncsyscolumns@n  n 0R## M$88 44 88 44 44 ncsyscolumns@n n0R## M@$88 44 88 44 44 ncsyscolumnsHn bn nf 1MM*>{T<{T<{T<{T<{T<M@FA !,7BMXcny)4?JU`kv&1<GR]hs~ #.9D@bbbbb4@n cnBAn  nTT  en n  WW Pn n4 Ln b n DHn n Pn  nPn  n4n k 1n\<<0TtHLdM  P}H 0 1ncsystypes } @} m8XXHS   44  @ @  44@@ncsystypes@0R@,xsystypes/0,00/m8cb/m8m8$[7m8@0m8)b,08m808m8jc,07m87ZftK$g7d0"bd7m8m8Yvt,0tm8m8h\ 0 0## M$ @  CREE UNIQUE NCLUSTERED DEX ncsystes ONystypes ( sertype ) nuer ) TENIQUE NCSTEREDND ncsysjes N sobjec (tm8pm8m8d ) @ S  D} n)7`D} c}*7pL} & 8Z%L} &}.%,} &@c8} }%,} }P}   n$ P}   } ( }   } 0R%% &44ncsystypes}  @ } 0R%% &44ncsystypes}  }0R%% &44ncsystypesH}  n} @ } 1*=*=*=|A $-6?HQZclu~"#$048:;<=>chjlz} @ }TT   e}  }  WW L} n } D} } P}  }HP}  }4}  1}hdDxpD H` X`G 1 D c3$xXc 1\ 0q P P  1sysfilegroupsx H<=0&`44=groupidX #Hn 6`groupid IE0&`44Eallocpolicy` #H&6`&@llocpolicyt J;0&`88 ;statusT #J6`status| KA0&`Agroupname\ #J"6`"groupnameD  `}+7`X@ 7 1"AllocMixedExtent8  c3 %08  cO%4  1 7D  c ,7pL (` 8Z'L (`.', `(c@L '`   }x0R`'' (^xsysfilegroups  `m8 }L0*`S  1 Lsysfilegroups` U (6`(sysfilegroupsHD !b  `P  P  P  4  1hm804 DL<T\8haP , P0( 1sysfilegroups `@m8XXHN `@  44 @ R`'' (^xsfilegroup @ `@''  (44@@sysfilegroups@0R`'' (^xsysfilegroupsX807d7m8v^bm88m8^b0m8fb8m8,00//|m8|m8Hbm800/`1/0hm8ffj00,0/tm8cb/X00,00/m80,00m8)b,00d10m8jc,00tm8Cm8@0$7m8m8Yvm8́C,00`m8/*L .28m8D IND sysfilegrp``S 8m8vDm8hh----------------------- crte table sfshm8uv m8p`tm8pm8m8T NULL, allocpolicy smallint NOT NULL, stat@s int NOT NULL, groupname sysname ) `S D `-7`D c.7pL *` 8Z)L *`.),H*@c8`)D  `/7`L  *`4+8 ` +LP h`u P,, `L (`.'D ` +` 8 c $7pL  :  8Z9L : .9,  :cL9 8@r0R 99#:^rsysdepends  m8F0* S a1 Fsysdepends\"6 "sysdependsD!  P HP P 4a1l,hH$T` P $ H01sysdepends  @m8XXHM8m8 @ o 0( 0m8*_o 0[sysc88 44 88 44  10030/,0m87p0r0R 99#:^rsysdepends 0R@@;=#<88 44 88 44  sysdepends 0R @;=#<88 44 88 44  sysdepends @0R @;=#<88 44 88 44  sysdependsTT   WW LH    D    P  P 41d`@tD  P P1sysreferencesxf =0&88 =constidX#f 6constidtg;0&88 ;fkeyidT#g6fkeyid@th;0&88   ;rkeyidT#h6rkeyid|iA0&44Arkeyindid\#i"6"rkeyindidt j;0&44@;keycntT #h 6keycntx k =0& =forkeysX #h 6forkeysx l =0& =refkeysX#j 6refk@ysD =7 `D c>70pL : 8Z9L :.9,:cL98x0R99@i:^xsysreferences m8  L0*S 1 Lsysreferences` (6(sysreferencesD!  P P HP 41 8 T pPT(L8hDt8heP 0 T0B1ucsysreferences @m8XXHM8m8@o 0( 0m8*_o 0[sysc88     10030/,0m8L ?.>,@?@c8>X 7B1"AllocMixedExtentD!m8U1GrowFile, !cww0??ACGKOSS]ggkoswٰz_#@ * *@0??ACGKOSS]ggkoswٰz_#H * H*@PTlt,XN"4 !Y1 X#8  c(08# c(4 Y1 7D  D7`L# ?4@8# @LPP8$,#L$ :.9D$ #=` 8 c#'7p0$x0R99i:^xsysreferences@$$0R@>@i?v88 ucsysreferences$$0R@>@i?v88 ucsysreferences$$0R@>@@i?v88 ucsysreferences$  TT$ $   WWvxL$   $ D H$  $ P$ $ P$ $4c1@ pdP DP(T"01 nc1sysreferences ("@("m8XXHM8m8 o 0 ( 0m8*_o 0[sysc88 88    10030/,0m8@i?x88 ucsysreferences0,00/m8cb/m8m8$[7m80@>@i?88f\@ 0@ 0@CREE NONCLUSTED INDEX nsysreferens ON sreference( fkeyid )tm8pm8m8@ucsysreferencS D( "$=7 `D( "c(>70pL( ": 8Z9L( ":(.9,("@:c8("(9,( "(P( "$$ P( "( ( ( "( 0R99  :88 88 nc1sysreference@( "( 0R99  :88 88 nc1sysreferences("(0R99  :88 88 nc1sysreferences("$@TT("(  WWL(" $ ("D ( ("P( "(HP( "(4("1(PL,`|PTl s,P4T#01 nc2sysreferences 4#@4#m8XXHM8m8 o 0 ( 0m8*_o 0[sysc88  88    10030/,0m8@i?x88 ucsysreferences0,00/m8cb/m8m8$[7m8@0m8)b,08m808m8jc,07m87ZftK$g7d0"bd7m8m8Yvt,0tm8m8f\ 0 099  : @ 1sysrefereesCREE NONCLUSTED INDEX nsysreferens ON sreference( rkeyid )tm8pm8m8@ucsysrerencS  D4 #(E7`D4 #c4F7pL4 #B 8ZAL4 #B4.A,4#@Bc84#4A,4 #4P4 #($ P4 #4 ( 4 #4 0RAA  B88  88 nc2sysreference@4 #4 0RAA  B88  88 nc2sysreferences4#40RAA  B88  88 nc2sysreferences4#(HTT4#4  WWD ( 0 4#P4 #444#14D$`|PTls,P ?\$#1&sysfulltextcatalogsx?$m=0&44=ftcatidX?$#m6ftcatidp?$n?70&7nameP?$#n?6na@et?$o?;0&44;statusT?$#o?6statusp?$p?70&7pathP?$#o?6pathD?  $4G7`D?  $c? @7pL?  $D 8ZCL?  $D? .C,? $DcL?$C8?$40RCC%D^sysfulltextcatalogs ?$m8@?$ 4X0*S #1 Xsysfulltextcatalogsl?$464sysfulltextcatalogsD?$!  P? $?P? $?P? $H?4?$#1?hm800@$`<xDtHmP 8 D\%0n1&sysfulltextcatalogs D%@D%m8XXHM8m8@o 0 ( 0m8*_o 0[sysc44    10030/,0m8d1DMLd>, o,6@,db_backupoperator4 >cQ0h`d>, ,6@,db_backupoperatorP >o 4>d1PTX<?d1DML4?d1TX<@d1DML4@d12.TPHA d1sysobjects AD0@ ALA  A|A sC0&88  Cschema_ver\A#? @$6 $schema_verA. O0 O([base_schema_ver] & ((~15))) A O0&88  Ostats_schema_verh A# 06 0stats_schema_ver A. E0 E([base_sch@ema_ver] & 15)p A  70&7typeP A#  6typeA. 0(convert(char(2),case when (([xtype] = 'UQ' or [xtype] = 'PK')) then 'K' else [xtype] end))xA@ ?0&44?userstatXA#  6 userstatA.0(convert(smallint,case when (([xtype] = 'S' or [xtype] = 'U')) then 1 else 0 end))xA=0&44@=sysstatXA# 6sysstatHA. 0 (convert(smallint,(case [xtype] when 'S' then 1 when 'V' then 2 when 'U' then 3 when 'P' then 4 when 'RF' then 4 when 'X' then 4 when 'L' then 5 when 'D' then@ 6 when 'R' then 7 when 'TR' then 8 when 'PK' then 9 when 'UQ' then 9 when 'C' then 10 when 'F' then 11 when 'AP' then 13 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 1 <> 0) then 16 else 0 end + case when ([status]@ & 2 <> 0) then 32 else 0 end + 64 + case when (substring([name],1,1) = '#') then 256 else 0 end + case when ([status] & 0x01000000 <> 0) then 512 else 0 end + case when ([status] & 0x200000 <> 0) then 1024 else 0 end + case when ([status] & 0x04000000 <> @0) then 2048 else 0 end + case when ([status] & 4 <> 0) then 8192 else 0 end + case when ([status] & 0x02000000 <> 0) then 16384 else 0 end + case when (substring([name],1,2) = '##') then (-32768) else 0 end) else 0 end)))HBd1SplitN@xtXCd1"AllocMixedExtentDDd1GrowFile,Dc ww0??ACGKOSS]ggkoswٰz_#H * *@0??ACGKOSS]ggkoswٰz_#P * *@`x \ 8(P0`HeXN4Dd1P,X*,8Cc#)8 CcM)4Cd1D BL`L B* :HLBH&LBHBH@@9;A;9;?;5?3;9;9;;7?3==;;;;;;;;5;759CC;?39;A;=;;A;===7;7=E;A99;E=o0&009xtype0&00;status0&44Axusertype0&44;length0&00 9xprec0&00  ;x@scale0&88   ?tdefault0&88  ;domain0&44  5uid0&44  ?reserved0&88 3id0&44;number0&44 9colid0&44  ;status0&@@9ctext0&88 ;status0&44;fileid0& 7name0& ?filename0& 88 3id0& 44=grantee0& 44 =grantor0& 44  ;actad@d0& 44 ;actmod0& ;seladd0& ;selmod0& ;updadd0&  ;updmod0&  ;refadd0&  ;refmod0& 445uid0& 44@;status0& 7name0& U5sid0& 9roles0& ==Ccreatedate0& ==Cupdatedate0& 44;altuid0&  ?password0& 88 3id@& 88 9depid0& 44  ;number0& 44 Adepnumber0& 44;status0&88 =constid0&88 ;fkeyid0&88   ;rkeyid0&44Arkeyindid0&44@;keycnt0& =forkeys0& =refkeys0&44=ftcatid0&7name0&44;status0&7path0&`44=groupid0&`44@Eallocpolicy0&`88 ;status0&`Agroupname0&b88 9objid0&b449indid0&b44 ;fileid0&b88   Egaminterval0&b=iampage< B?@H@L B* HP B4Bd1@xA ?0&44?indexdelX A# 6 indexdelA.0@(convert(smallint,(([base_schema_ver] & ((~15))) / 65536)))xA =0&===refdateXA#6refdateA.M0M(convert(datetime,[crdate]))xA@=0&88 =versionXA#6versionpA.505(convert(int,0))xA=0&88 =deltrigXA#6deltrigA@S0S(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableDeleteTrigger')) when ([xtype] = 'TR') then [parent_obj] else 0 end))xA=0&88 =instrigXA@#6instrig<A. 0(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableInsertTrigger')) else 0 end))xA=0&88 =updtrigX@A#6updtrig<A. 0(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableUpdateTrigger')) else 0 end))xA=0&88 =seltrig@XA# 6seltrigp A. 505(convert(int,0))x!A?0&88 ?categoryX"A#  6 category#A. !u0u(convert(int@,(case when ([status] & 0x80000000 <> 0) then 2 else 0 end + case when ([replinfo] & 1 <> 0) then 32 else 0 end + case when ([replinfo] & 2 <> 0) then 64 else 0 end + case when ([replinfo] & 4 <> 0) then 256 else 0 end + case when ([xtype] = 'P' and [statu@s] & 2 <> 0) then 16 else 0 end + case when ([xtype] = 'D' and [parent_obj] <> 0) then 2048 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 0x20 <> 0) then 1 else 0 end + case when ([status] & 0x0400 <> 0) then 4 else @0 end + case when ([status] & 0x0800 <> 0) then 8 else 0 end + case when ([status] & 0x1000 <> 0) then 128 else 0 end + case when ([status] & 0x0100 <> 0) then 512 else 0 end + case when ([status] & 0x0200 <> 0) then 1024 else 0 end + case when ([status] &@ 0x2000 <> 0) then 2048 else 0 end + case when ([status] & 0x4000 <> 0) then 4096 else 0 end + case when ([status] & 0x10 <> 0) then 16384 else 0 end) else 0 end)))t$A"90&449cacheT%A##6@cachex&A. $?0?(convert(smallint,0))P' A P(A(: >@P) A )P* A*4Ad1H)|),)((('L'D\PDtPPdhLP.0P,HEnd1sysindexes ED ELE EtE4%;0&88 ;maxlenTE#%&6@maxlen\E.'!0!(8000)p E570&88 7rowsP E#/6rows\ E. !0!(case when (convert(int,[rowcnt]) <> 0) then 2147483647 else (coHnvert(int,convert(binary(8),reverse(convert(char(8),[rowcnt]))))) end)P E +P E P E4Ed104tP0`P/)*HFe1syscolumns FD0@ FLF FtFI ;0&00;statusTF#C 6@statusF. 0(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 else 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 @<> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <> 0 or (type_name([xtype]) = 'timestamp' or type_name([xtype]) = 'char' or type_name([xtype]) = 'binary') and [typestat] & 1 = 0))@ then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end)))p FJ70&007typeP F#D6type F. 0@(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))x FK ?0&44?usertypeX F#F  6 usertypeF. 0(convert(smallint,columnproperty([id],[name],'@oldusertype')))xFL ?0&?printfmtXF#B 6 printfmtF.W0W(convert(varchar(255),[autoval]))pFM70&447precP@#B6prec0F.0(convert(smallint,case when ((type_name([xtype]) = 'ntext' or type_name([xtype]) = 'image' or type_name([xtype]) = 'text')) then null when (type_name([xtype]) = 'uniqueidentifier') then @[xprec] else (odbcprec([xtype],[length],[xprec])) end))tFN90&88 9scaleTF#E6scaleF.O0O(odbcscale([xtype],[xscale]))|FOC0&@8 Ciscomputed\F#>$6$iscomputedHGe1SplitNextD GM`L G/:ILGI.LG.@GI u?!!WO0u(convert(int,(case when ([status] & 0x80000000 <> 0) then 2 else 0 end + case when ([replinfo] & 1 <> 0) then 32 else 0 end + case when ([replinfo] & 2 <> 0) then 64 else 0 end + case when ([replinfo] & 4@ <> 0) then 256 else 0 end + case when ([xtype] = 'P' and [status] & 2 <> 0) then 16 else 0 end + case when ([xtype] = 'D' and [parent_obj] <> 0) then 2048 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 0x20 <> 0) the@n 1 else 0 end + case when ([status] & 0x0400 <> 0) then 4 else 0 end + case when ([status] & 0x0800 <> 0) then 8 else 0 end + case when ([status] & 0x1000 <> 0) then 128 else 0 end + case when ([status] & 0x0100 <> 0) then 512 else 0 end + case when ([sta@tus] & 0x0200 <> 0) then 1024 else 0 end + case when ([status] & 0x2000 <> 0) then 2048 else 0 end + case when ([status] & 0x4000 <> 0) then 4096 else 0 end + case when ([status] & 0x10 <> 0) then 16384 else 0 end) else 0 end)))0?(convert(smallin@t,0))0!(8000)0!(case when (convert(int,[rowcnt]) <> 0) then 2147483647 else (convert(int,convert(binary(8),reverse(convert(char(8),[rowcnt]))))) end)0(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 els@e 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 <> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <@> 0 or (type_name([xtype]) = 'timestamp' or type_name([xtype]) = 'char' or type_name([xtype]) = 'binary') and [typestat] & 1 = 0)) then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end))@)0(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))0(convert(smallint,columnproperty([id],[name],'oldusertype')))0W(convert(varchar(255),[autoval]))0(convert(smallint,case when ((type_name([xtype]) = 'ntex@t' or type_name([xtype]) = 'image' or type_name([xtype]) = 'text')) then null when (type_name([xtype]) = 'uniqueidentifier') then [xprec] else (odbcprec([xtype],[length],[xprec])) end))0O(odbcscale([xtype],[xscale]))< G. I @L!G0IP" G 4Ge1 FI  ]0](convert(int,sign(([colstat] & 4))))|%FPC0&88 Cisoutparam\&F#@?$6$isoutparam'FI %]0](convert(int,sign(([colstat] & 4))))|(FQ&C0&88 Cisnullable\)F#?'$6$isnullable*FI (_0_(cHonvert(int,(1 - ([typestat] & 1))))P+ F# P, F , P- F-4Fe18)((H('T'&@&%h%$$L$$#p$<8p@ X pP0`I8FP *DH'e1systypes HD0@ HLH  HxHH ?0&44  ?usertypeXH#Y* 6@  usertypeHI +0 (convert(smallint,typeproperty([name],'oldusertype')))x HH ?0&hh  ?variableX H#Z 6  variablex HI =0 =(conve@rt(bit,case when ((type_name([xtype]) = 'nvarchar' or type_name([xtype]) = 'varchar' or type_name([xtype]) = 'varbinary')) then 1 else 0 end))| HH  C0&hhCallownulls\ H#R $6$allownulls@HI [0[(convert(bit,(1 - ([status] & 1))))pHH  70&007typePH#Y6typeHIe0e(convert(tinyint,xtypetotds([xtype],0)))xH@H?0&?printfmtXH#V 6 printfmtHIM0M(convert(varchar(255),null))pHH70&447precPH#V6pr@cHI{0{(convert(smallint,case when ((type_name([xtype]) = 'ntext' or type_name([xtype]) = 'image' or type_name([xtype]) = 'text')) then null else (typeproperty([name],'precision')) end))tHH90&00@9scaleTH#Y6scaleHIs0s(convert(tinyint,typeproperty([name],'scale')))PH .: ,-P H P HHP H4He1l | , ,  D dL PL,|\ePP LIp e1syscomments ID 0 ILI  IxIH?0&44?texttypeXI#i@ 6 texttypeIIm0m(convert(smallint,(2 + 4 * ([status] & 1))))x IH?0&44?languageX I#g 6 languagex II ?0?(convert(sma@llint,0))| IH A0&hhAencrypted\ I#f "6"encryptedII O0O(convert(bit,([status] & 1)))|IH C0&hh  Ccompressed\@#e$6 $compressedIIO0 O(convert(bit,([status] & 2)))pIH70&@  7textPI#l6 textII0 (convert(nvarcha@r(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))P I PI : abP IP I4IHe1 H DLtD$T4d IP  HJ e1sysdepends J D 0 J LJ   J xJH8=0& 44=depdbidXJ#@ depdbidxJI?0 ?(convert(smallint,0))| JH9A0& 44Adepsiteid\ J#"6 "depsiteidx JI ?0 ?(convert(smallint,0))t J@: ;0& hh;selallT J# 6 selallJI O0 O(convert(bit,([status] & 2)))|JH; A0& hh  Aresultobj\J#"6 "re@ultobjJIO0 O(convert(bit,([status] & 4)))xJH<=0& hh  =readobjXJ#6 readobjJIO0 O(convert(bit,([status] & 8)))PH: #$ P J P JP J4J e10 @h8\p P0`JsH6PeR=> PKe1sysreferences KD @P KLK ) KxKHD?0&44?fkeydbidXK#@ 6 fkeydbidxKI?0?(convert(smallint,0))x KHE?0&44  ?rkeydbidX K# 6  rkeydbidx KI ?0 ?(convert(smallint,0))t K@F 90&44  9fkey1T K# 6 fkey1KI  0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],1,2))),0)))tKHG 90&44  @9fkey2TK#6 fkey2KI!0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))tKHH90&44  9fkey3TK#@6 fkey3KI"0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))tKHI90&44  9fkey4TK#6 fkey4KI@#0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))tKHJ90&449fkey5TK#6fkey5KI$0(convert(s@mallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))tKHK90&449fkey6TK#6fkey6HLe1SplitNextD LN`L L@@JL LJIL!LIJ"LJ!sm?OO??OOO??0s(convert(tinyint,typeproperty([name],'scale')))0m(convert(smallint,(2 + 4 * ([status] & 1@))))0?(convert(smallint,0))0O(convert(bit,([status] & 1)))0 O(convert(bit,([status] & 2)))0 (convert(nvarchar(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))0 ?(convert(smallint,@0))0 ?(convert(smallint,0))0 O(convert(bit,([status] & 2)))0 O(convert(bit,([status] & 4)))0 O(convert(bit,([status] & 8)))0?(convert(smallint,0))0 ?(convert(smallint,0))0 (convert(smallint,isnull(c@onvert(binary(2),reverse(substring([forkeys],1,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))0 @(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))<# LI"J`L$L0"JP% L@ 4Le1KJ#0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],11,2))),0)))t(KHL90&449fkey7T)K#@6fkey7*KJ(0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],13,2))),0)))t+KHM)90&449fkey8T,K#*6fkey8-K@+0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],15,2))),0)))t.KHN,90&449fkey9T/K#-6fkey90KJ.0(convert@(smallint,isnull(convert(binary(2),reverse(substring([forkeys],17,2))),0)))t1KHO/;0&44;fkey10T2K#06fkey103KJ10(convert(smallint,isnull(convert(binary(2)@,reverse(substring([forkeys],19,2))),0)))t4KHP2;0&44;fkey11T5K#36fkey116KJ40(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2)@)),0)))t7KHQ5;0&44;fkey12T8K#66fkey129KJ70(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))t:KHR8@;0&44;fkey13T;K#96fkey13<KJ:0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],25,2))),0)))t=KHS;;0&44;fkey14T@>K#<6fkey14?KJ=0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],27,2))),0)))t@KHT>;0&44;fkey15TAK#?6@key15BKJ@0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],29,2))),0)))tCKHUA;0&44;fkey16TDK#B6fkey16EKJC@(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],31,2))),0)))tFKHVD90&449rkey1TGK#E6rkey1HKJF0(convert(smallint,isnull@(convert(binary(2),reverse(substring([refkeys],1,2))),0)))tIKHWG90&449rkey2TJK#H6rkey2KKJI0(convert(smallint,isnull(convert(binary(2),reverse(substri@ng([refkeys],3,2))),0)))tLKHXJ90&449rkey3TMK#K6rkey3NKJL0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],5,2))),0)))tO@HYM90&449rkey4TPK#N6rkey4QKJ O0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],7,2))),0)))tRKHZP90&44@9rkey5TSK#Q6rkey5TKJ!R0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],9,2))),0)))tUKH[S90&449rkey6TVK#@T6rkey6WKJ"U0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],11,2))),0)))tXKH\V90&44  9rkey7TYK#W6 rkey7ZK@J#X0 (convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],13,2))),0)))t[KH]Y90&44!!9rkey8T\K#Z6!rkey8]KJ$[0!(conve@rt(smallint,isnull(convert(binary(2),reverse(substring([refkeys],15,2))),0)))t^KH^\90&44""9rkey9T_K#]6"rkey9`KJ%^0"(convert(smallint,isnull(convert(binary(@2),reverse(substring([refkeys],17,2))),0)))taKH__;0&44##;rkey10TbK#`6#rkey10cKJ&a0#(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],19,H2))),0)))tdKH`b;0&44$$;rkey11< ;:X:d9987T7655$5043h3t2 210d0/..4.@-,x,+0+*)t)) ('D'P&%%$@$#"""! T ` P ,dp<d4 \  L  (`l\p(X8h3h3t2 210d0/..4.@-,x,+0+*)t)) ('D'P&%%$@$#"""! T ` P ,dp<d4 \  L  (`lK0fJ/HP>H0n exn 5x6x6xr tr l p n Hmaster.mdfcw (gl (* Zw`YwMcwj w wi (* (j ( "*j RC,j RCpl wȰwl l Xw Zw`YwYw C:\TEMP\modellog.ldf(*  \l yw3 8l < w0wl Lw 3 l Em w w l @l 03 3 4Dp IK  .ldfog"ww4@af1P TeK#c6$rkey11KJ'd0$(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))tKHae;0&44%%;rkey12TK#@6%rkey12KJ(0%(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))tKHb;0&44&&;rkey13TK#6&rkey13KJ@)0&(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))tKHc;0&44'';rkey14T K#6'rkey14 KJ*0'(convert(s@mallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))t KHd ;0&44((;rkey15T K# 6(rkey15 KJ+ 0((convert(smallint,isnull(convert(binary(2),r@everse(substring([refkeys],29,2))),0)))tKHe ;0&44));rkey16TK# 6)rkey16KJ,0)(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],31,2)))H,0)))PK&: inP K ""P K""P K4Kaf1L \  P\L(`lP9.0 DMkf1sysusers M D@P M LM   M pMH370& 44  7suidPM#6 @suidMJu0 u(convert(smallint,suser_id(suser_sname([sid]))))p MH450& 44  5gidP M#6 gidHNkf1SplitNextD  NO@`L  N/ FKLNKJLNJ KHNK0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],19,2)))@,0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(s@ubstring([forkeys],25,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],27,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],29,2))),0)))0(convert(smallint,isnull(c@onvert(binary(2),reverse(substring([forkeys],31,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],1,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],3,2))),0)))0@(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],5,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],7,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkey@s],9,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],11,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],13,2))),0)))0!(convert(smallint,isnull(convert(binary(2)@,reverse(substring([refkeys],15,2))),0)))0"(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],17,2))),0)))0#(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],19,2))),0)))0$(convert(smallin@t,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))0%(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))0&(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))@'(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0((convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)(convert(smallint,isnull(convert(binary(2),reverse(substri@ng([refkeys],31,2))),0)))< NJKLN0%KP N 4 Nkf1  MJ0 (convert(smallint,case when ([uid] >= 16400) then [uid] wh@en ((datalength([roles]) is null or datalength([roles]) <= 2)) then 0 else (16384 - 8 + datalength([roles]) * 8 + case when (convert(tinyint,[roles]) & 1 <> 0) then 0 when (convert(tinyint,[roles]) & 2 <> 0) then 1 when (convert(tinyint,[roles]) & 4 <> 0) @then 2 when (convert(tinyint,[roles]) & 8 <> 0) then 3 when (convert(tinyint,[roles]) & 16 <> 0) then 4 when (convert(tinyint,[roles]) & 32 <> 0) then 5 when (convert(tinyint,[roles]) & 64 <> 0) then 6 when (convert(tinyint,[roles]) & 128 <> 0) then 7 end)@ end))xMH5 =0&   =environXM# 6 environMJM0 M(convert(varchar(255),null))MH6E0& 88  Ehasdbaccess`M@&6 &hasdbaccessMJ 0 (convert(int,case when ([status] & 2 = 2) then 1 else 0 end))xMH7=0& 88 =isloginXM#6 islogin MJ @0 (convert(int,case when ([status] & 32 = 0 and [uid] > 0 and [uid] < 16384) then 1 else 0 end))xMH8?0& 88 ?isntnameX M# 6  isntname!MJ 0 @(convert(int,case when ([status] & 4 = 4) then 1 else 0 end))|"MH9 A0& 88 Aisntgroup\#M#!"6 "isntgroup$MJ "0 (convert(int,case when ([status] & 12 = 4) t@hen 1 else 0 end))x%MH:#?0& 88 ?isntuserX&M#$ 6  isntuser'MJ %0 (convert(int,case when ([status] & 12 = 12) then 1 else 0 end))|(MH;&A0&@88 Aissqluser\)M#'"6 "issqluser *MJ(0 (convert(int,case when ([status] & 60 = 0 and [uid] > 0 and [uid] < 16384) then 1 else 0 end))|+MH<)A0& 88 @Aisaliased\,M#*"6 "isaliased-MJ+0 (convert(int,case when ([status] & 16 = 16) then 1 else 0 end))|.MH=,A0& 88 Aissqlrole\/M#-"@ "issqlrole0MJ.0 (convert(int,case when (([uid] >= 16384 or [uid] = 0)) then 1 else 0 end))|1MH>/A0& 88 Aisapprole\2M#0"6 "isapprole3MJ@10 (convert(int,case when ([status] & 32 = 32) then 1 else 0 end))P4M:  P5 M 5 P6 M6 P7 M74MHkf1--L-,,+++$*)L)($('&@&%$$($\##"!d! Hh@ p4T|, L,|\6 #0P0.LOof1sysindexkeysHPof1SplitNextD. P P`L. P@LL.PLH&L.PH2L.PL.@?9;A;=A;A==;;A;==??999999999;;;;;;;999999999;;;;;;;=7;7=E;A99;E=0& 88 9depid0& 44  ;number0& 44 Adepnumber0& 44;status0& 44=depdbid0& 44Adepsiteid@0& hh;selall0& hh  Aresultobj0& hh  =readobj0&88 =constid0&88 ;fkeyid0&88   ;rkeyid0&44Arkeyindid0&44;keycnt0&@ =forkeys0& =refkeys0&44?fkeydbid0&44  ?rkeydbid0&44  9fkey10&44  9fkey20&44  9fkey30&44  9fkey40&44@9fkey50&449fkey60&449fkey70&449fkey80&449fkey90&44;fkey100&44;fkey110&44;fkey120&44;fke@y130&44;fkey140&44;fkey150&44;fkey160&449rkey10&449rkey20&449rkey30&449rkey40&449rkey50&44@9rkey60&44  9rkey70&44!!9rkey80&44""9rkey90&44##;rkey100&44$$;rkey110&44%%;rkey120&44&&;rkey130&44'';rkey1@40&44((;rkey150&44));rkey160&44=ftcatid0&7name0&44;status0&7path0&`44=groupid0&`44Eallocpolicy0&`88 @;status0&`Agroupname0&b88 9objid0&b449indid0&b44 ;fileid0&b88   Egaminterval0&b=iampage<. PH@.L?L.P@  LP. P84.Pof1.?l.OL6.30&88 3idL. O#36idt. OL7. 90&449indidT.O#@. 6indidt.OL8.90&44 9colidT.O#.6colidt.OL9.90&44  9keynoT.O#.6keyno.O. v@R^vsysindexkeys .O.O J0*S  of1 Jsysindexkeys`.O?&6&sysindexkeysD.O! ? P. O.HP. O.P. O.4.Otf1.`|xt8p$4<d0X0;@Q}f1 grrevL;Q1   P; Q. 4;Q}f1;d6XPd <PR}f1sysforeignkeysx<RL:.=0&88 =constidX<R#.6constidt<RL;<;0&88 ;fkeyidT<R#<6fkeyid@t<RL<<;0&88   ;rkeyidT<R#<6rkeyidp<RL=<70&447fkeyP<R#<6fkeyp< RL><70&447rkeyP@ R#< 6rkeyt< RL?< 90&449keynoT< R#< 6keyno< R;z0R'^zsysforeignkeys <R<R@ .N0*S  }f1 Nsysforeignkeysd<R.*6*sysforeignkeysD<R! . P< R<P< R<P< R<H4<R}f1<dlH8t8h<X0 A@Sf1 grrevLAS1 ; PA S< 4ASf1Ad6XP4BHTf1sysmembers|BTL@< A0&44Amemberuid\BT#< "6"memberuidxBTLAB?0&44?groupuidXBT#B 6 grou@uidBTAr0R^rsysmembers BTBT <F0*S  f1 Fsysmembers\BT <"6"sysmembersDB T! < PBH TBPB TB PB TB 4BTf1BDT8` pX0E@Uf1 grrevLEU1 A PE UB 4EUf1Ed5XP` FLVf1sysprotectslFVLBB30&88 3idLFV#B6idpFVLCF50&445uidPFV#F6uidtFVLD@F;0&00 ;actionTFV#F6actionFVLEFE0&00  Eprotecttype`FV#F&6&protecttypexF VLFF=0&=columnsX@F V#F 6columnsxF VLGF =0&44  =grantorXF V#F 6grantorF V Et0R^tsysprotects FVF@BH0*S  f1 Hsysprotects\FV B $6$sysprotectsDFV!B  PF VFPF VFPF VFH4FVf1F`p$T$PdVX0 K@Wf1 grrevLKW1 E PK WF 4KWf1Kd5XP LDXf1sysfilestLXLHF ;0&_44;fileidTLX#F 6_fileidxLXLIL=0&_44=groupidXLX#L6_groupidpL@XLJL70&_88 7sizePLX#L6_sizexLXLKL=0&_88   =maxsizeXLX#L6_maxsizetL XLLL;0&_88 ;growthT@ X#L 6_growthtL XLML ;0&_88 ;statusTL X#L 6_statuspL XLNL 70&_88 7perfPLX#L 6_perfpLXLOL@70&_7namePLX#L6_namexLXLPL?0&_  ?filenameXLX#L 6_  filenameLX!Kn0R_$6^nsys@iles LX_|LXFB0*_S  f1 BsysfilesXLXF6_sysfilesDLX!F _PL XLPL XLPL XHL 4LXf1L4 D , d DL,d$\fLX0 R@Yf1 grrevLRY1 K_ PR YL 4RYf1Rd5XPnSD c(A:s^tLZf1syssegmentsxSZLZL=0&:s88 =segmentXSZ#L6:ssegmentpSZL[S70&:s 7namePSZ@S6:snametSZL\S;0&:s88 ;statusTSZ#S6:sstatus SZ:sS ZLH0*:sV f1 Hsyssegments\S ZL$6:s$syssegmentsD@S Z!L :sS ZK0:sCREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 PS Z RPS ZSPS ZSH4SZf1SDx(@ 8x \#X0W@[f1 grrevLW[1 R:s PW [S 4W[f1Wd3XPvXD cS(A^tuP\f1sysconstraintsxX\L]S=0&^t88 =constidXX\#S6^tconstidlX\L^X30&^t88 3idLX\@X6^tidtX\L_X90&^t449colidTX\#X6^tcolidtX\L`X;0&^t00;spare1TX \#X6^tspare1tX \LaX ;0&@^t88 ;statusTX \#X 6^tstatusxX \LbX =0&^t88 =actionsXX \#X 6^tactionstX\LcX 90&^t88 9errorTX\#X@6^terrorPX\;  ^t PX\; X^tPX\; X^tPX\; X^tPX\; X^t X\^tX\S@N0*^tV f1 NsysconstraintsdX\S *6^t*sysconstraintsDX\!S  ^tX\KS 0^tCREATE VIEW sysconstraints AS SELECT constid = convert(int, id), id = convert(int, parent_obj), colid = convert(smallint, info), spare1 = convert(tinyint, 0), status@= convert(int, CASE xtype WHEN 'PK' THEN 1 WHEN 'UQ' THEN 2 WHEN 'F' THEN 3 WHEN 'C' THEN 4 WHEN 'D' THEN 5 ELSE 0 END + CASE WHEN info != 0 -- CNST_COLUMN / CNST_TABLE THEN (16) ELSE (32) END + CASE WHEN (status & 16)!=0 -- CNST_CLINDEX THEN (512) ELSE 0 END + CASE WHEN (status & 32)!=0 -- CNST_NCLINDEX THEN (1024) ELSE 0 END + (2048) -- CNST_NOTDEFERRABLE + CASE WHEN (status & 256)!=0 -- CNST_DISABLE THEN (16384) ELSE 0 END + CASE WHEN @status & 512)!=0 -- CNST_ENABLE THEN (32767) ELSE 0 END + CASE WHEN (status & 4)!=0 -- CNST_NONAME THEN (131072) ELSE 0 END + CASE WHEN (status & 1)!=0 -- CNST_NEW THEN (1048576) ELSE 0 END + CASE WHEN (status & 1024)!=0 -- CNST_REPL THEN (2097152) ELSE 0 END), actions = convert(int, 4096), error = convert(int, 0) FROM sysobjects WHERE xtype in ('C', 'F', 'PK', 'UQ', 'D') AND (status & 64) = 0 PX \ WHPX \XPX \X PX \X4X\f1X́Cd  \dt$\8p4|$\( #X0`@]f1 grrevL`]1 W^t P` ]X 4`]f1`d3XP.aD cX(AuXvP^f1sysalternatespa^LdX70&u447suidPa^#X6usuidxa^Lea=0&u44=altsuidXa^#@a6ualtsuidPa^; Xu Pa^; au Pa^; au  a ^ua ^XL0*uV f1 Lsysalternates`a ^X@(6u(sysalternatesDa ^!X u a ^KX0uCREATE VIEW sysalternates AS SELECT suid = convert(smallint, suser_id(substring(name, 2, 63))), altsuid = convert(smallint, suser_id(suser_sname(user_sid(altuid)))) FROM sysusers WHERE isaliased = 1 Pa ^ `Pa ^HaPa ^a Pa ^a4a^f1áC4t0L,<l\X0e@_f1 grrevLe_1 `u Pe _a 4e_f1ed3XXzf`v=g1_Xgfmg1f,q Xzh`f#z1`Xih(z1h 8q P j<ap81DMLljaa  F1Hljaj  F1Hljaj c1 F1Hljaj 1 B1D@ljaj  1 H1Jljaj  D1Fljaj T 1 N1P ljaj  1 B1D lj aj a1 @1H lj a j 1 L1Nlj a j #1 X1Zlj a j of1 J1Llj a j }f1 N1Plja j@f1 F1Hljaj f1 H1Jljaj f1 B1D_ljaj  1 L1N`ljaj  N1PbljaHj f1 H1J:sljaj f1 N1P^tljaj f1 L1Nu4ja1jp80 X<d Hp,T FX@ oLb1UpdateUsagePobe( Pobo$ 4ob1o|p8p8dXpLc1UpdateUsagePpco$  Ppcp( Ppcp$ Xpcp, 4pc1pTdX@qLd1UpdateUsagePqdp( Pqdq$ 4qd1q|p8p8dX@rLe(1UpdateUsagePre q( Pre r$ 4re(1r|p8p8dX@sLf11UpdateUsagePsf r( Psf s$ 4sf11s|p8p8dXtLg61UpdateUsagePtg s  Ptg t( Ptg t$ 4tg61t|p8p8TdX@uLh?1UpdateUsagePuht(  Puhu$  4uh?1u|p8p8dX@vLiI1UpdateUsagePviu(  Pviv$  4viI1v|p8p8dX@wLjM1UpdateUsagePwjv(  Pwjw$  4wjM1w|p8p8dX@xLk\1UpdateUsagePxkw( Pxkx$ 4xk\1x|p8p8dX@yLl`1UpdateUsagePylx( Pyly$ 4yl`1y|p8p8dX@zLmj1UpdateUsagePzm#y( `Pzm#z$ `4zmj1z|p8p8dX{Lnn1UpdateUsageP{n%z  bP{n%{( bP{n%{$ b4{nn1{|p8p8TdXz|`h1nX}|1|#q Xz~`|1oX~1~ 8q X@py2 grrevP p{ 4py2dV0$0XX@q~2 grrevP q 4q~2dV0$0XX0@r~2 grrevLr1 e P r 4r~2dV0$0XX0@s2 grrevLs1  P s 4s2dV0$0XX0@t2 grrevLt1   P t 4t2dV0$0XX0@u2 grrevLu1  P u 4u2dV0$0XX0@v2 grrevLv1  P v 4v2dV0$0XX@w2 grrevP w 4w2dV0$0XX0@x2 grrevLx1   P x 4x2dV0$0XX@y2 grrevP y 4y2dV0$0XX0@z2 grrevLz1  P z 4z2dV0$0XX0@{2 grrevL{1   P { 4{2dV0$0XX0@|2 grrevL|1  P | 4|2dV0$0XX@}2 grrevP } 4}2dV0$0XX0@~2 grrevL~1 ` P ~ 4~2dV0$0XX0@2 grrevL1  P  42dV0$0XX`~2D caxX,2>B7q X`2D cAxX2>B7q P<f3DML4 oL0f3f3KKLINFORMATION_SCHEMAh, .6.INFORMATION_SCHEMA@7 oP  4f3HR0@TP-]^D c(AXv˿wDf3SCHEMATALfaG0&XvGCATALOG_NAMEH/f3SplitNextD .Q/`L $n4ML@M0 M.  $ $0  ", "" &  $$$  "$   "$"   $&""" "" $"""  @" "& &"&6.base_schema_ver6cache6 category6 crdate6deltrig6 ftcatid6id6 indexdel6info6instrig6name6 $parent_obj6refdate6@ replinfo6 $schema_ver6seltrig6 0stats_schema_ver6status6sysstat6type6uid6updtrig6 userstat6version6xtype6csid6 dpages6first6 FirstIAM6grou@id6id6impid6indid6keycnt6keys6"lockflags6maxirow6maxlen6minlen6name6,OrigFillFactor6 pgmodctr6  reserved6"reserved26root6 rowcnt6 "rowmodct@6rows6soid6 statblob6status6&StatVersion6 used6xmaxlen6autoval6 bitpos6 cdefault6 colid6 colorder6 colstat6domain6id6$iscomputed6$isnullable@$isoutparam6length6name6number6offset6prec6 printfmt6  reserved6scale6status6type6 typestat6 usertype6 xoffset6xprec6xscale6xtype6"xu@ertype6$allownulls6 domain6length6name6prec6 printfmt6  reserved6scale6status6 tdefault6type6 uid6  usertype6  variable6xprec6xscale6xtype6@"xusertype6colid6 $compressed6ctext6"encrypted6id6 language6number6status6 text6 texttype6fileid6 filename6name6status6 actadd6 actmod6 gran@ee6 grantor6 id6 refadd6 refmod6 seladd6 selmod6 updadd6 updmod6 altuid6 $createdate6 environ6 gid6 &hasdbaccess6 "isaliased6 "isapprole6 islogin6 "is@tgroup6  isntname6  isntuser6 "issqlrole6 "issqluser6 name6  password6 roles6 sid6 status6 suid6 uid6 $updatedate6 depdbid6 depid6 "depnumber6 "depsiteid6 @id6 number6 readobj6 "resultobj6 selall6 status6constid6 fkey16fkey106fkey116fkey126fkey136fkey146fkey156fkey166 fkey26 fkey36 fkey46@fkey56fkey66fkey76fkey86fkey96 fkeydbid6fkeyid6forkeys6keycnt6refkeys6rkey16#rkey106$rkey116%rkey126&rkey136'rkey146(rkey156)rkey166@rkey26rkey36rkey46rkey56rkey66 rkey76!rkey86"rkey96  rkeydbid6rkeyid6"rkeyindid6ftcatid6name6path6status6colid6id6indid6@keyno6constid6fkey6fkeyid6keyno6rkey6rkeyid6 groupuid6"memberuid6action6columns6grantor6id6&protecttype6uid6_fileid6_  filename6_groupi@6_growth6_maxsize6_name6_perf6_size6_status6`&allocpolicy6`groupid6`"groupname6`status6bfileid6b&gaminterval6biampage6bindid6bobjid6:sname6:ssegment@:sstatus6^tactions6^tcolid6^tconstid6^terror6^tid6^tspare16^tstatus6ualtsuid6usuid#a.  $ $0  ", "" &  $$$  "$ @  "$"   $&""" "" $"""  " "& &"&6.base_schema_ver6cache6 category6 crdate6deltrig6 ftca@id6id6 indexdel6info6instrig6name6 $parent_obj6refdate6 replinfo6 $schema_ver6seltrig6 0stats_schema_ver6status6sysstat6type6uid6updtrig6 @serstat6version6xtype6csid6 dpages6first6 FirstIAM6groupid6id6impid6indid6keycnt6keys6"lockflags6maxirow6maxlen6minlen6name6,@rigFillFactor6 pgmodctr6  reserved6"reserved26root6 rowcnt6 "rowmodctr6rows6soid6 statblob6status6&StatVersion6 used6xmaxlen6autoval6 bitpos6 cdefault@ colid6 colorder6 colstat6domain6id6$iscomputed6$isnullable6$isoutparam6length6name6number6offset6prec6 printfmt6  reserved6scale6status6@type6 typestat6 usertype6 xoffset6xprec6xscale6xtype6"xusertype6$allownulls6 domain6length6name6prec6 printfmt6  reserved6scale6status6 tdef@ult6type6 uid6  usertype6  variable6xprec6xscale6xtype6"xusertype6colid6 $compressed6ctext6"encrypted6id6 language6number6status6 text6@ texttype6fileid6 filename6name6status6 actadd6 actmod6 grantee6 grantor6 id6 refadd6 refmod6 seladd6 selmod6 updadd6 updmod6 altuid6 $createdate6 @environ6 gid6 &hasdbaccess6 "isaliased6 "isapprole6 islogin6 "isntgroup6  isntname6  isntuser6 "issqlrole6 "issqluser6 name6  password6 roles6 sid6 status6 @suid6 uid6 $updatedate6 depdbid6 depid6 "depnumber6 "depsiteid6 id6 number6 readobj6 "resultobj6 selall6 status6constid6 fkey16fkey106fkey116fk@y126fkey136fkey146fkey156fkey166 fkey26 fkey36 fkey46fkey56fkey66fkey76fkey86fkey96 fkeydbid6fkeyid6forkeys6keycnt6refkeys6@key16#rkey106$rkey116%rkey126&rkey136'rkey146(rkey156)rkey166rkey26rkey36rkey46rkey56rkey66 rkey76!rkey86"rkey96  rkeydbid6rkeyid6"rk@yindid6ftcatid6name6path6status6colid6id6indid6keyno6constid6fkey6fkeyid6keyno6rkey6rkeyid6 groupuid6"memberuid6action6colu@ns6grantor6id6&protecttype6uid6_fileid6_  filename6_groupid6_growth6_maxsize6_name6_perf6_size6_status6`&allocpolicy6`groupid6`"groupname6`status@bfileid6b&gaminterval6biampage6bindid6bobjid6:sname6:ssegment6:sstatus6^tactions6^tcolid6^tconstid6^terror6^tid6^tspare16^tstatus6ualtsuid6usuidD @# D #  l # 26M2base_schema_verP 4g3R0p8H/g3SplitNextD R/`L @$:NLN0M LMNP  Nr "" $"""  " "&@ &"&6  isntuser6 "issqlrole6 "issqluser6 name6  password6 roles6 sid6 status6 suid6 uid6 $updatedate6 depdbid6 depid6 "depnumber6 "depsit@id6 id6 number6 readobj6 "resultobj6 selall6 status6constid6 fkey16fkey106fkey116fkey126fkey136fkey146fkey156fkey166 fkey26 fkey36 fk@y46fkey56fkey66fkey76fkey86fkey96 fkeydbid6fkeyid6forkeys6keycnt6refkeys6rkey16#rkey106$rkey116%rkey126&rkey136'rkey146(rkey156)@key166rkey26rkey36rkey46rkey56rkey66 rkey76!rkey86"rkey96  rkeydbid6rkeyid6"rkeyindid6ftcatid6name6path6status6colid6id6indi@6keyno6constid6fkey6fkeyid6keyno6rkey6rkeyid6 groupuid6"memberuid6action6columns6grantor6id6&protecttype6uid6_fileid6_  filename6_@groupid6_growth6_maxsize6_name6_perf6_size6_status6`&allocpolicy6`groupid6`"groupname6`status6bfileid6b&gaminterval6biampage6bindid6bobjid6:sname6:s@egment6:sstatus6^tactions6^tcolid6^tconstid6^terror6^tid6^tspare16^tstatus6ualtsuid6usuid< MNr p8\# $6 N$isntuserP @4g3R0r`Nr(6Xv(CATALOG_NAMELgE0&XvESCHEMA_NAME`Ns&6Xv&SCHEMA_NAMELhG0&XvGSCHEMA_OWNE@R`Nt(6Xv(SCHEMA_OWNERLii0&XviDEFAULT_CHARACTER_SET_CATALOGNsJ6XvJDEFAULT_CHARACTER_SET_CATALOG Ljg0&XvgDEFAULT@_CHARACTER_SET_SCHEMA!Nt H6XvHDEFAULT_CHARACTER_SET_SCHEMA"Lk!c0&XvcDEFAULT_CHARACTER_SET_NAME|#Nt"D6XvDDEFAULT_CHARACTER_SET_NAME $Xv|%@jB0*XvV g3 BSCHEMATAX&a 6XvSCHEMATAD'!a  XvD(Ka 0Xv  --Identifies schmata owned by current users, databases current users has permissions in create view INFORMATION_SCHEMA.SCHEMATA as select db.name as CATALOG_NAME ,USER_NAM@() as SCHEMA_NAME ,USER_NAME() as SCHEMA_OWNER ,'master' as DEFAULT_CHARACTER_SET_CATALOG ,'dbo' as DEFAULT_CHARACTER_SET_SCHEMA ,a_cha.name as DEFAULT_CHARACTER_SET_NAME FROM master.dbo.sysdatabases db, master.dbo.sysconfigures cfg, master.dbo.syscharsets a_cha, --charset/1001, not sortorder. master.dbo.syscharsets b_cha --sortorder/2001, not charset. WHERE cfg.comment = 'default sortorder id' AND a_cha.type = 1001 --- type is charset AND b_cha.type = 2001 --- type is sorHorder AND a_cha.id = b_cha.csid AND b_cha.id = cfg.value P)  P* *P+ +4g3p8p80]\\@\XX`XWWHWV,VUUdTTS$SRDRRQdQ(Q$CBB0*˿wV g3 >TABLEST@'6˿wTABLESD!( ˿wK)0˿w--Identifies tables accessible to the current user create view INFORMATION_SCHEMA.TABLES as select distinct db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME ,case o.xtype when 'U' then 'BASE TABLE' when 'V' then 'VIEW' end as TABLE_TYPE fHom sysobjects o where o.xtype in ('U', 'V') and permissions(o.id) != 0 P  P P  P 4g3́CR0 @ P@tTd<d \rTX0 @h3 grrevL1 ˿w P  4h3dR0R0XP#D c(AxyXh3"TABLE_CONSTRAINTSLp S0&xSCONSTRAINT_CATALOGlN| 46x4CONSTRAINT_CATALOGLqQ0&x@QCONSTRAINT_SCHEMAlN}26x2CONSTRAINT_SCHEMALrM0&xMCONSTRAINT_NAMEhN}.6x.CONSTRAINT_NAMELsI0&xITAB@LE_CATALOGd N*6x*TABLE_CATALOG Lt G0&xGTABLE_SCHEMA` N (6x(TABLE_SCHEMA| Lu C0&xCTABLE_NAME\ N@ $6x$TABLE_NAMELv M0&x MCONSTRAINT_TYPEhN.6x.CONSTRAINT_TYPELwI0&xIIS_DEFERRABLEdN*6x*IS_DEFER@ABLELxS0&x SINITIALLY_DEFERREDlN46x 4INITIALLY_DEFERREDP; x P; xP; xP@; xP; x x4T0*xV  h3 TTABLE_CONSTRAINTSh06x0TABLE_CONSTRAINTSD! x0@K0x--Identifies table constraints owned by current users create view INFORMATION_SCHEMA.TABLE_CONSTRAINTS as select db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,case c_obj.xtype when 'C' then 'CHECK' when 'UQ' then 'UNIQUE' when 'PK' then 'PRIMARY KEY' @ when 'F' then 'FOREIGN KEY' end as CONSTRAINT_TYPE ,'NO' as IS_DEFERRABLE ,'NO' as INITIALLY_DEFERRED from sysobjects c_obj ,sysobjects t_obj where c_obj.uid = user_id() and t_obj.id = c_obj.parent_obj and c_obj.xtype in ('C' ,'UQ' ,'PK' ,'F') P  P P  HP! ! 4h3́CR0\ l @ D T   $4\|,8@\ RX0@h3 grrevL1 x P " 4h3dR0Y0XP, "D c(Ay<8zTi3 TABLE_PRIVILEGESxLy=0&y=GRANTORXN6yGRANTORH/i3SplitNextD S@/`L .FOLOL&LLOt O<79A?35;E==;=7=;;77?=E;A99;E==7;=39;;=97=GEGigcIGCCSQMIGCMIS=0&447rkey0&44@9keyno0&44Amemberuid0&44?groupuid0&88 3id0&445uid0&00 ;action0&00  Eprotecttype0&=columns0&44  =grant@or0&_44;fileid0&_44=groupid0&_88 7size0&_88   =maxsize0&_88 ;growth0&_88 ;status0&_88 7perf0&_7name0&_ @ ?filename0&`44=groupid0&`44Eallocpolicy0&`88 ;status0&`Agroupname0&b88 9objid0&b449indid0&b44 ;fileid0&b88  @ Egaminterval0&b=iampage0&:s88 =segment0&:s 7name0&:s88 ;status0&^t88 =constid0&^t88 3id0&^t449colid0&^t00;spa@re10&^t88 ;status0&^t88 =actions0&^t88 9error0&u447suid0&u44=altsuid0&XvGCATALOG_NAME0&XvESCHEMA_NAME0&XvGSCHEM@A_OWNER0&XviDEFAULT_CHARACTER_SET_CATALOG0&XvgDEFAULT_CHARACTER_SET_SCHEMA0&XvcDEFAULT_CHARACTER_SET_NAME0&˿wITABLE_CATALOG0&˿wGTABLE_SCHEMA0&˿w@CTABLE_NAME0&˿w CTABLE_TYPE0&xSCONSTRAINT_CATALOG0&xQCONSTRAINT_SCHEMA0&xMCONSTRAINT_NAME0&xITABLE_CATALOG0&xGTABLE_SCHEMA0&x@CTABLE_NAME0&x MCONSTRAINT_TYPE0&xIIS_DEFERRABLE0&x SINITIALLY_DEFERRED0&y=GRANTOR< L> O<<p8L . OP @4i3R0<xO< =0&y=GRANTEEXN6yGRANTEEO=I0&yITABLE_CATALOGdN*6@*TABLE_CATALOGO>G0&yGTABLE_SCHEMA`N(6y(TABLE_SCHEMA|O?C0&yCTABLE_NAME\N$6y$TABLE_NAMEO@@K0&y KPRIVILEGE_TYPEdN,6y,PRIVILEGE_TYPEOAG0&yGIS_GRANTABLE`N(6y(IS_GRANTABLEP; yP@; yP; yP; yP; yP; yP ;  yP!; @!yP"; "yP#; #y $y4%R0*yV i3 RTABLE_PRIVILEGESh&.6y.TABLE_PRIVILEGESD'!@ yH/i3SplitNextX/i3"AllocMixedExtentDp8i3GrowFile,+cww0??ACGKOSS]ggkoswٰz_#P *@0??ACGKOSS]ggkoswٰz_#XH *@h tx(8HHd(@p<dX (\yXN"4+i3+P 8*c*R08 c*4*i3*/D) T/`L /LPLPKLKPP@ p80"(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],17,2))),0)))0#(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],19,2))),0)))0$(convert(smallint,isnull(conve@rt(binary(2),reverse(substring([refkeys],21,2))),0)))0%(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))0&(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))0'(con@vert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0((convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],3@1,2))),0)))0:sCREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 0^tCREATE VIEW sysconstraints AS SELECT constid = convert(int, id), id = convert(int, parent_obj), colid = convert(smallint, info), spare1 = convert(tinyint, 0), status = convert(int, CASE xtype WHEN 'PK' THEN 1 WHEN 'UQ' THEN 2 WHEN 'F' THEN 3 WHEN 'C' THEN 4 WHEN 'D' @HEN 5 ELSE 0 END + CASE WHEN info != 0 -- CNST_COLUMN / CNST_TABLE THEN (16) ELSE (32) END + CASE WHEN (status & 16)!=0 -- CNST_CLINDEX THEN (512) ELSE 0 END + CASE WHEN (status & 32)!=0 -- CNST_NCLINDEX THEN (1024) ELSE 0 END + (2048) -- CNST_NOTDEFERRABLE + CASE WHEN (status & 256)!=0 -- CNST_DISABLE THEN (16384) ELSE 0 END + CASE WHEN (status & 512)!=0 -- CNST_ENABLE THEN (32767) ELSE 0 END + CASE WHEN (status & 4)!=0 -- CNST_NONAME @THEN (131072) ELSE 0 END + CASE WHEN (status & 1)!=0 -- CNST_NEW THEN (1048576) ELSE 0 END + CASE WHEN (status & 1024)!=0 -- CNST_REPL THEN (2097152) ELSE 0 END), actions = convert(int, 4096), error = convert(int, 0) FROM sysobjects WHERE xtype in ('C', 'F', 'PK', 'UQ', 'D') AND (status & 64) = 0 0uCREATE VIEW sysalternates AS SELECT suid = convert(smallint, suser_id(substring(name, 2, 63))), altsuid = convert(smallint, suser_id(suser_sname(@ser_sid(altuid)))) FROM sysusers WHERE isaliased = 1 0Xv  --Identifies schmata owned by current users, databases current users has permissions in create view INFORMATION_SCHEMA.SCHEMATA as select db.name as CATALOG_NAME ,USER_NAME() as SCHEMA_NAME ,USER_NAME() as SCHEMA_OWNER ,'master' as DEFAULT_CHARACTER_SET_CATALOG ,'dbo' as DEFAULT_CHARACTER_SET_SCHEMA ,a_cha.name as DEFAULT_CHARACTER_SET_NAME FROM master.dbo.sysdatabases db, master.dbo.sysconfigures cf@, master.dbo.syscharsets a_cha, --charset/1001, not sortorder. master.dbo.syscharsets b_cha --sortorder/2001, not charset. WHERE cfg.comment = 'default sortorder id' AND a_cha.type = 1001 --- type is charset AND b_cha.type = 2001 --- type is sortorder AND a_cha.id = b_cha.csid AND b_cha.id = cfg.value 0˿w--Identifies tables accessible to the current user create view INFORMATION_SCHEMA.TABLES as select distinct db_name() as TABLE_CATALOG ,user_name(o.uid) as @ABLE_SCHEMA ,o.name as TABLE_NAME ,case o.xtype when 'U' then 'BASE TABLE' when 'V' then 'VIEW' end as TABLE_TYPE from sysobjects o where o.xtype in ('U', 'V') and permissions(o.id) != 0 0x--Identifies table constraints owned by current users create view INFORMATION_SCHEMA.TABLE_CONSTRAINTS as select db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME ,db_name() as TABLE_CATALOG ,use@_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,case c_obj.xtype when 'C' then 'CHECK' when 'UQ' then 'UNIQUE' when 'PK' then 'PRIMARY KEY' when 'F' then 'FOREIGN KEY' end as CONSTRAINT_TYPE ,'NO' as IS_DEFERRABLE ,'NO' as INITIALLY_DEFERRED from sysobjects c_obj ,sysobjects t_obj where c_obj.uid = user_id() and t_obj.id = c_obj.parent_obj and c_obj.xtype in ('C' ,'UQ' ,'PK' ,'F') < KHp8L 0"PP   4)i3)R0X LPPrTgu TP P (P 0y --Identifies privileges granted to or by the current user create view INFORMATION_SCHEMA.TABLE_PRIVILEGES as select user_name(p.grantor) as GRANTOR ,user_name(p.uid) as GRANTEE ,db_name() as @TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME ,case p.action when 26 then 'REFERENCES' when 193 then 'SELECT' when 195 then 'INSERT' when 196 then 'DELETE' when 197 then 'UPDATE' end as PRIVILEGE_@TYPE ,case when p.protecttype = 205 then 'NO' else 'YES' end as IS_GRANTABLE from sysprotects p, sysobjects o where (is_member(user_name(p.uid)) = 1 or p.grantor = user_id()) and (p.protecttype = 204 or /*grant exists @without same grant with grant */ (p.protecttype = 205 and not exists(select * from sysprotects p2 where p2.id = p.id and p2.uid = p.uid and p2.action = p.action and p2.columns = p.columns and p2.grantor = p.grantor and @p2.protecttype = 204))) and p.action in (26,193,195,196,197) and p.id = o.id and o.xtype in ('U', 'V') and 0 != (permissions(o.id) & case p.action when 26 then 4 /*REFERENCES basebit on all columns */ when 193 then 1 /*SELECT b@asebit on all columns */ when 195 then 8 /*INSERT basebit */ when 196 then 16 /*DELETE basebit */ when 197 then 2 /*UPDATE basebit on all columns */ end) P   P HP  P 4i3́CR0 X  h X0@i3 grrevL1 y P  4i3dR0:0XPV8:D c(A<8zu\{Dj3COLUMNSOBI0&<8zITABLE_CATALOGdN*6<8z*TABLE_CATALOGOCG0&<8zGTABLE_SCH@EMA`N(6<8z(TABLE_SCHEMA|ODC0&<8zCTABLE_NAME\N$6<8z$TABLE_NAMEOEE0&<8zECOLUMN_NAME` N&6<8z@&COLUMN_NAME OF O0&<8z44OORDINAL_POSITIONh N 06<8z0ORDINAL_POSITION OG K0&<8z@KCOLUMN_DEFAULTd N ,6<8z,COLUMN_DEFAULT@OH E0&<8zEIS_NULLABLE`N&6<8z&IS_NULLABLE|OIA0&<8zADATA_TYPE\N"6<8z"DATA_TYPEOJ_0&<8z44 @ _CHARACTER_MAXIMUM_LENGTHxN@6<8z @CHARACTER_MAXIMUM_LENGTHOK[0&<8z44 [CHARACTER_OCTET_LENGTHtN<6<8z <CHARACTER_OCTET_LENGTHOLQ@&<8z00 QNUMERIC_PRECISIONlN26<8z 2NUMERIC_PRECISIONOM]0&<8z44 ]NUMERIC_PRECISION_RADIXxN>6<8z >NUMERIC_PRECISION_RADIXON@I0&<8z88 INUMERIC_SCALEdN*6<8z *NUMERIC_SCALEOOS0&<8z44SDATETIME_PRECISIONlN46<8z4DATETIME_PRECISIONOPY0&<8z@YCHARACTER_SET_CATALOGtN:6<8z:CHARACTER_SET_CATALOG OQW0&<8zWCHARACTER_SET_SCHEMAp!N 86<8z8CHARACTER_SET_SCHEMA"OR!S0&<8z@SCHARACTER_SET_NAMEl#N"46<8z4CHARACTER_SET_NAME$OS#Q0&<8zQCOLLATION_CATALOGl%N$26<8z2COLLATION_CATALOG&OT%O0&<8z@OCOLLATION_SCHEMAh'N&06<8z0COLLATION_SCHEMA(OU'K0&<8zKCOLLATION_NAMEd)N(,6<8z,COLLATION_NAME*OV)K0&<8zKDOMAIN_CATALO@Gd+N*,6<8z,DOMAIN_CATALOG,OW+I0&<8zIDOMAIN_SCHEMAd-N,*6<8z*DOMAIN_SCHEMA.OX-E0&<8zEDOMAIN_NAME`/N.@&6<8z&DOMAIN_NAMEP0; $<8zP1; 1<8zP2; 2<8zP3; 3<8zP4; 4<8zP5; 5<8z@P6; 6<8zP7; 7<8zP8; 8<8zP9; 9<8zP:; :<8zP;; ;<8z P<@; <<8zP=; =<8zP>; ><8zP?; ?<8zP@; @<8zPA;, A<8z PB;, B@<8zPC;, C<8z D<8zxE&@0*<8zV j3 @COLUMNSTF'6<8zCOLUMNSDG!( <8zH/j3SplitNextDI @U/`LJ /RQLKQPLLPQLM0 <8zQPN  4Ij3IR0HQ@L0<8z --Displays columns accessable to the current user create view INFORMATION_SCHEMA.COLUMNS as select db_name() as TABLE_CATALOG ,user_name(obj.uid) as TABLE_SCHEMA ,obj.name as TABLE_NAME ,col.name as CO@LUMN_NAME ,col.colid as ORDINAL_POSITION ,com.text as COLUMN_DEFAULT ,case col.isnullable when 1 then 'YES' else 'No ' end as IS_NULLABLE ,spt_dtp.LOCAL_TYPE_NAME as DATA_TYPE ,col.length + spt_dtp.charbin as CHA@RACTER_MAXIMUM_LENGTH ,col.prec + spt_dtp.charbin as CHARACTER_OCTET_LENGTH ,nullif(col.xprec, 0) as NUMERIC_PRECISION ,spt_dtp.RADIX as NUMERIC_PRECISION_RADIX ,col.scale as NUMERIC_SCALE ,spt_dtp.SQL_DATETIME_SUB as DATETIME_PRECIS@ION ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then 'master' else NULL end as CHARACTER_SET_CATALOG ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', '@nchar', 'nvarchar', 'ntext') then 'dbo' else NULL end as CHARACTER_SET_SCHEMA ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then a_cha.name else NULL end as CHARACT@ER_SET_NAME ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then 'master' else NULL end as COLLATION_CATALOG ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text',@ 'nchar', 'nvarchar', 'ntext') then 'dbo' else NULL end as COLLATION_SCHEMA ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then b_cha.name else NULL end as COLLATION@_NAME ,case when typ.xusertype < 256 then NULL else DB_NAME() end as DOMAIN_CATALOG ,case when typ.xusertype < 256 then NULL else USER_NAME(obj.uid) end as DOMAIN_SCHEMA ,case when typ.xusertype < 256 @ then NULL else typ.name end as DOMAIN_NAME FROM sysobjects obj, master.dbo.spt_datatype_info spt_dtp, systypes typ, syscolumns col LEFT OUTER JOIN syscomments com on col.cdefault = com.id AND com.colid = 1, master.dbo.sysco@nfigures cfg, master.dbo.syscharsets a_cha, --charset/1001, not sortorder. master.dbo.syscharsets b_cha --sortorder/2001, not charset. WHERE permissions(obj.id, col.name) != 0 AND obj.id = col.id AND typ.xtype = spt_dtp.ss_dtype AND (spt_dtp@.ODBCVer is null or spt_dtp.ODBCVer = 2) AND obj.xtype in ('U', 'V') AND col.xusertype = typ.xusertype AND spt_dtp.AUTO_INCREMENT in ( 0, null) AND cfg.comment = 'default sortorder id' AND a_cha.type = 1001 --- type is charset AND b_cha.type =@ 2001 --- type is sortorder AND a_cha.id = b_cha.csid AND b_cha.id = cfg.value PQ  OPR RPS S PT T4Hj3́CR077L766\x,\p 0@P`p 0Ph0<DHD D T X T T HTx @h$\0X0:@j3 grrevL1 <8z P U 4j3dR0C0XP#ND c(Au\{|\Wk3&COLUMN_DOMAIN_USAGEOY/K0&u\{KDOMAIN_CATALOGdN0,6u\{,DOMAIN_CATALOGOZI0&u\{@IDOMAIN_SCHEMAdN*6u\{*DOMAIN_SCHEMAO[E0&u\{EDOMAIN_NAME`N&6u\{&DOMAIN_NAMEO\I0&u\{ITABLE_CATALOGd @N*6u\{*TABLE_CATALOG O] G0&u\{GTABLE_SCHEMA` N (6u\{(TABLE_SCHEMA| O^ C0&u\{CTABLE_NAME\ N $6u\{$TABLE_@AMEO_ E0&u\{ECOLUMN_NAME`N&6u\{&COLUMN_NAMEP;/ Du\{P;/ u\{P;/ u\{P;2 @u\{P;2 u\{P;2 u\{P;5 u\{ P;5 u\{P;5 u\{ u\{@FX0*u\{V Wk3 XCOLUMN_DOMAIN_USAGElG46u\{4COLUMN_DOMAIN_USAGED!H u\{|QQA0u\{A --Identifies columns owned by current user that has a user defined datatype create view INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE as select db_name() @ as DOMAIN_CATALOG ,user_name(typ.uid) as DOMAIN_SCHEMA ,typ.name as DOMAIN_NAME ,db_name() as TABLE_CATALOG ,user_name(obj.uid) as TABLE_SCHEMA ,obj.name as TABLE_NAME ,col.name as COLUMN_NAME FROM sysobjects obj ,syscolumns col ,systypes typ WHERE obj.uid = user_id() AND obj.id = col.id AND col.xusertype = typ.xusertype AND typ.xusertype > 256 -- UDF Type P  P HP  P! !4Wk3́CR04  h h  x(80Ph$<\ NX0"@k3 grrevL"1 u\{ P" " 4"k3"dR040XP1B"$#D c(A|x}X8l3"COLUMN_PRIVILEGESx#O`=0&|=GRANTORX#N6|GRANTORx#Oa#=0&|=GRANTEEX@#N#6|GRANTEE#Ob#I0&|ITABLE_CATALOGd#N#*6|*TABLE_CATALOG#Oc#G0&|GTABLE_SCHEMA`# N#(6|@(TABLE_SCHEMA|# Od# C0&|CTABLE_NAME\# N# $6|$TABLE_NAME# Oe# E0&|ECOLUMN_NAME`# N# &6|&COLUMN_NAME#Of#@K0&| KPRIVILEGE_TYPEd#N#,6|,PRIVILEGE_TYPE#Og#G0&|GIS_GRANTABLE`#N#(6|(IS_GRANTABLEP#;8 |P#@;8 #|P#;8 #|P#;8 #|P#;8 #|P#;8 #|P#;8 #|P#;8 #@|P#;8 #|P#;8 #|P#;< #| P#;< #|P#;< #| #|4# @T0*|V =l3 TCOLUMN_PRIVILEGESh#!06|0COLUMN_PRIVILEGESD#"! |H/=l3SplitNextD#$ JV/`L#% /KXRL#&R@QL#'QRL#(0N|RP#)  "4#$=l3#$R0(##R#'0| --Identifies privileges granted to or by current user @ create view INFORMATION_SCHEMA.COLUMN_PRIVILEGES as select user_name(p.grantor) as GRANTOR ,user_name(p.uid) as GRANTEE ,db_name() as TABLE_CATALOG ,user_name(o.uid) as TAB@LE_SCHEMA ,o.name as TABLE_NAME ,c.name as COLUMN_NAME ,case p.action when 193 then 'SELECT' when 197 then 'UPDATE' else 'REFERENCES' @ end as PRIVILEGE_TYPE ,case when p.protecttype = 205 then 'NO' else 'YES' end as IS_GRANTABLE from sysprotects p, sysob@jects o, syscolumns c where (is_member(user_name(p.uid)) = 1 or p.grantor = user_id()) and (p.protecttype = 204 or /*grant exists without same grant with grant */ (p.protecttype = 205 and not exists(@select * from sysprotects p2 where p2.id = p.id and p2.uid = p.uid and p2.action = p.action and p2.columns = p.columns and @ p2.grantor = p.grantor and p2.protecttype = 204))) and p.action in (26,193,197) and p.id = o.id and o.xtype in ('U', 'V') and o.id = c.id and (((convert(tinyint,substring(p.columns,1,1))&1@) = 0 and (convert(int,substring(p.columns,c.colid/8+1,1))&power(2,c.colid&7)) != 0) or ((convert(tinyint,substring(p.columns,1,1))&1) != 0 and (convert(int,substring(p.columns,c.colid/8+1,1))&power(2,c.colid&7)) = 0)) and 0 != (perm@issions (o.id, c.name) & case p.action when 26 then 4 /*REFERENCES basebit */ when 193 then 1 /*SELECT basebit */ when 197 then 2 /*@UPDATE basebit */ end) P#,  #*P#- #-P#. #. P#/ #/4#=l3#́CR0!\! ! l Dt( L  X H \ l  | , <<Xt<T,\ X0$5@l3 grrevL51 "| P5 #0 45l35dR0a0XPD466D c#(Ax} l~Dm3DOMAINS6Oh#K0&x}KDOMAIN_CATALOGd6N#,6x},DOMAIN_CATALOG6Oi6I0&x}IDOMAIN_SC@HEMAd6N6*6x}*DOMAIN_SCHEMA6Oj6E0&x}EDOMAIN_NAME`6N6&6x}&DOMAIN_NAME|6Ok6A0&x}ADATA_TYPE\6 N6@"6x}"DATA_TYPE6 Ol6 _0&x}44_CHARACTER_MAXIMUM_LENGTHx6 N6 @6x}@CHARACTER_MAXIMUM_LENGTH6 Om6 [0&x}44[CHARACTER_OCTET_LENGTHt6 N6 @<6x}<CHARACTER_OCTET_LENGTHH/m3SplitNextD6 #%W/`L6 LSL6SO&L6O6 S6S66MIS==IGCKGIGC@OKEA_[Q]ISYWSQOKKIEKIEIGCE==IGCEKGKIEA_[G0&x MCONSTRAINT_TYPE0&xIIS_DEFERRABLE0&x SINITIALLY_DEFERRED0&y=GRANTOR0&y=GRANTEE0&yITABLE_C@ATALOG0&yGTABLE_SCHEMA0&yCTABLE_NAME0&y KPRIVILEGE_TYPE0&yGIS_GRANTABLE0&<8zITABLE_CATALOG0&<8zGTABLE_SCHEMA0&<8zCTABLE_N@AME0&<8zECOLUMN_NAME0&<8z44OORDINAL_POSITION0&<8z@KCOLUMN_DEFAULT0&<8zEIS_NULLABLE0&<8zADATA_TYPE0&<8z44 _CHARACTER_MAXIMUM_LENGTH0&<8z44 @[CHARACTER_OCTET_LENGTH0&<8z00 QNUMERIC_PRECISION0&<8z44 ]NUMERIC_PRECISION_RADIX0&<8z88 INUMERIC_SCALE0&<8z44SDATETIME_PRECISION0&<8zYCHARACTER_SET_CATALOG0&<8z@WCHARACTER_SET_SCHEMA0&<8zSCHARACTER_SET_NAME0&<8zQCOLLATION_CATALOG0&<8zOCOLLATION_SCHEMA0&<8zKCOLLATION_NAME0&<8zKDOMAIN_CATALOG0&<8zIDOM@AIN_SCHEMA0&<8zEDOMAIN_NAME0&u\{KDOMAIN_CATALOG0&u\{IDOMAIN_SCHEMA0&u\{EDOMAIN_NAME0&u\{ITABLE_CATALOG0&u\{GTABLE_SCHEMA0&u\{@CTABLE_NAME0&u\{ECOLUMN_NAME0&|=GRANTOR0&|=GRANTEE0&|ITABLE_CATALOG0&|GTABLE_SCHEMA0&|CTABLE_NAME0&|ECOLUMN_NAME@&| KPRIVILEGE_TYPE0&|GIS_GRANTABLE0&x}KDOMAIN_CATALOG0&x}IDOMAIN_SCHEMA0&x}EDOMAIN_NAME0&x}ADATA_TYPE0&x}44_CHARACTER_MAX@IMUM_LENGTH0&x}44[CHARACTER_OCTET_LENGTH<6 O86S6p8L6 xSP6 546m36R066S66Q0&x}QCOLLATION_CAT@ALOGl6N626x}2COLLATION_CATALOG6S76O0&x}OCOLLATION_SCHEMAh6N606x}0COLLATION_SCHEMA6S86K0&x} KCOLLATION_NAMEd6@N6,6x} ,COLLATION_NAME6S96Y0&x} YCHARACTER_SET_CATALOGt6N6:6x} :CHARACTER_SET_CATALOG6 S:6W0&x} WCHARACTER_SET_SCHEMAp6!@6 86x} 8CHARACTER_SET_SCHEMA6"S;6!S0&x} SCHARACTER_SET_NAMEl6#N6"46x} 4CHARACTER_SET_NAME6$S<6#Q0&x}00 QNUMERIC_PRECISIONl6%N@6$26x} 2NUMERIC_PRECISION6&S=6%]0&x}44]NUMERIC_PRECISION_RADIXx6'N6&>6x}>NUMERIC_PRECISION_RADIX6(S>6'I0&x}00INUMERIC_SCALEd6)N@6(*6x}*NUMERIC_SCALE6*S?6)S0&x}44SDATETIME_PRECISIONl6+N6*46x}4DATETIME_PRECISION6,S@6+K0&x}@KDOMAIN_DEFAULTd6-N6,,6x}@,DOMAIN_DEFAULTP6.;E #x}P6/;E 6/x}P60;E 60x} P61;E 61x}P62;E 62x}P63;E 63x}@P64;E 64x}P65;E 65x}P66;E 66x}P67;N 67x} P68;N 68x}P69;N 69x} 6:x}@x6;#!@0*x}V m3 @DOMAINST6<#"6x}DOMAINSD6=!## x} 6>R#,M 0x}M --Identifies user defined datatype accessible to current user. create view INFORMATION_SCHEMA.DOMAINS as select DB_NAME() as DOMAIN_CATALOG ,USER_NA@E(typ.uid) as DOMAIN_SCHEMA ,typ.name as DOMAIN_NAME ,spt_dtp.LOCAL_TYPE_NAME as DATA_TYPE ,typ.length + spt_dtp.charbin as CHARACTER_MAXIMUM_LENGTH ,typ.prec + spt_dtp.charbin as CHARACTER_OCTET_LENGTH ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then 'master' else NULL end as COLLATION_CATALOG ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then 'dbo' @ else NULL end as COLLATION_SCHEMA ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then b_cha.name else NULL end as COLLATION_NAME ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then 'master' else NULL end as CHARACTER_SET_CATALOG ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then 'dbo' @ else NULL end as CHARACTER_SET_SCHEMA ,case when spt_dtp.LOCAL_TYPE_NAME in ('char', 'varchar', 'text', 'nchar', 'nvarchar', 'ntext') then a_cha.name else NULL end as CHARACTER_SET_NAME ,nullif(typ.xprec, 0) as NUMERIC_PRECISION ,spt_dtp.RADIX as NUMERIC_PRECISION_RADIX ,typ.scale as NUMERIC_SCALE ,spt_dtp.SQL_DATETIME_SUB as DATETIME_PRECISION ,com.text as DOMAIN_DEFAULT FROM master.dbo.spt_datatype_info spt_dtp, systypes typ LEFT OUTER J@IN syscomments com on typ.tdefault = com.id AND com.colid = 1, master.dbo.sysconfigures cfg, master.dbo.syscharsets a_cha, --charset/1001, not sortorder. master.dbo.syscharsets b_cha --sortorder/2001, not charset. WHERE typ.xtype = spt_dtp.ss_dtype AND (spt_dtp.ODBCVer is null or spt_dtp.ODBCVer = 2) -- Use 7.0 entries AND spt_dtp.AUTO_INCREMENT in ( 0, null) -- Remove auto increment types AND cfg.comment = 'default sortorder id' AND a_cha.type = 1001 --- type is charse@ AND b_cha.type = 2001 -- type is sortorder AND a_cha.id = b_cha.csid AND b_cha.id = cfg.value AND typ.xusertype > 256 -- UDF Type P6?  6P6@ 6@P6A 6A P6B 6B46m36H́CR0338322)(x((''@'&&P&&%`%%$p$ $#8#"@"!X! H PXXPhx Ltd@8(Pp $\tO MN0EX06Q@dm3 grrevLQ1 5x} PQ 6C 4Qdm3QdR0L0XP$8RD c6(A l~Y`Xm3$DOMAIN_CONSTRAINTSRSA6-S0& l~SCONSTRAINT_CATALOGlRN6.46 l~4CONSTRAINT_CATALOGRSBRQ0& l~@QCONSTRAINT_SCHEMAlRNR26 l~2CONSTRAINT_SCHEMARSCRM0& l~MCONSTRAINT_NAMEhRNR.6 l~.CONSTRAINT_NAMERSDRK0& l~KDOM@AIN_CATALOGdR NR,6 l~,DOMAIN_CATALOGR SER I0& l~IDOMAIN_SCHEMAdR NR *6 l~*DOMAIN_SCHEMAR SFR E0& l~EDOMAIN_NAME`R N@R &6 l~&DOMAIN_NAMERSGR I0& l~IIS_DEFERRABLEdRNR*6 l~*IS_DEFERRABLERSHRS0& l~SINITIALLY_DEFERREDlRNR46 l~4@NITIALLY_DEFERREDPR;Q 6: l~PR;Q R l~PR;Q R l~PR;Q R l~PR;U R l~ PR;U R l~ @PR;U R l~PR;U R l~ R l~R6<V0* l~V m3 VDOMAIN_CONSTRAINTSlR6=26 l~2DOMAIN_CONSTRAINTSDR!6>  l@xRR6?@0 l~@ --Identifies user defined datatype accessible to current user, that have constraints create view INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS as select DB_NAME() as CONSTRAINT_CATALOG ,USER_NAME(obj.uid) as CONSTRAINT_SCHEMA ,obj.name as CONSTRAINT_NAME ,DB_NAME() as DOMAIN_CATALOG ,USER_NAME(typ.uid) as DOMAIN_SCHEMA ,typ.name as DOMAIN_NAME ,'NO' as IS_DEFERRABLE ,'NO' as INITIALLY_DEFERRED FROM @ sysobjects obj, systypes typ WHERE obj.xtype = 'R' and obj.id = typ.domain AND typ.xusertype > 256 -- UDF Type PR  QPR R PR! R! PR" R"4Rm3ŔCR0l| T H T  d  t$,Dd|,8@\ ~IX0[@En3 grrevL[1 Q l~ P[ R# 4[En3[dR0k0XPA\D cR(AY`UTn3 KEY_COLUMN_USAGE\SIRS0&Y`SCONSTRAINT_CATALOGl\NR46Y`4CONSTRAINT_CATALOG\SJ\Q0&Y`@QCONSTRAINT_SCHEMAl\N\26Y`2CONSTRAINT_SCHEMA\SK\M0&Y`MCONSTRAINT_NAMEh\N\.6Y`.CONSTRAINT_NAME\SL\I0&Y`ITABLE@_CATALOGd\ N\*6Y`*TABLE_CATALOG\ SM\ G0&Y`GTABLE_SCHEMA`\ N\ (6Y`(TABLE_SCHEMA|\ SN\ C0&Y`CTABLE_NAMEH/n3@SplitNextD\ 6X/`L\ $@TL\TN L\N\ TP\ [\T\*(p86Y`*TABLE_CATALOG6Y`@(TABLE_SCHEMA<\ N\TXp8h\#.6Y`T.TABLE_CATALOGP\ \4\n3\R0\\ T\$6Y`$TABLE_NAME\SO\ E0&Y`@ECOLUMN_NAME`\N\&6Y`&COLUMN_NAME\SP\O0&Y`44OORDINAL_POSITIONh\N\06Y`0ORDINAL_POSITIONP\;Y RY` P\;Y \@Y`P\;Y \Y`P\ ;Y \ Y`P\!;Y \!Y`P\";^ \"Y` P\#;^ \#Y`P\$;^ \$Y`P@%;a \%Y`P\&;a \&Y`P\';a \'Y`P\(;a \(Y`P\);a \)Y`P\*;a \*Y`P\+;a @+Y`P\,;a \,Y`P\-;a \-Y`P\.;a \.Y`P\/;a \/Y`P\0;a \0Y`P\1;a \1Y` @P\2;a \2Y` P\3;a \3Y` P\4;a \4Y` P\5;a \5Y`P\6;^ \6Y`P\7;^ \7Y`P\8@^ \8Y`P\9;^ \9Y` \:Y`4\;RR0*Y`V n3 RKEY_COLUMN_USAGEh\<R.6Y`.KEY_COLUMN_USAGED\=!R Y`H@/n3SplitNextDp8n3GrowFile,\@c,ww0??ACGKOSS]ggkoswٰz_#X *@0??ACGKOSS]ggkoswٰz_#` *@l(48HXhx(8H X  h  x  ( L  `$D`Hx(4<\X;\\XNi4\@o3\@Pj8\?+R0Lj \\/Dj j\/@8j /#&+p8LjXRLjRRXLj0#)Y`XP@j  \4\?o3\?R0 \>Xj} 0Y`} --Identifies columns owned by current which are constrained key create view INFORMATION_SCHEMA.KEY_COLUMN_USAGE as select db_name() as CONSTR@AINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,col.name as COLUMN_NAME ,col.colid as ORDINAL_P@OSITION from sysobjects c_obj ,sysobjects t_obj ,syscolumns col ,sysreferences ref where c_obj.uid = user_id() and c_obj.xtype in ('F ') and t_obj.id = c_obj.parent_obj and t_obj.id = col.id and col.colid in (ref.fkey1,ref.fkey2@,ref.fkey3,ref.fkey4,ref.fkey5,ref.fkey6, ref.fkey7,ref.fkey8,ref.fkey9,ref.fkey10,ref.fkey11,ref.fkey12, ref.fkey13,ref.fkey14,ref.fkey15,ref.fkey16) and c_obj.id = ref.constid union select db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.@uid) as CONSTRAINT_SCHEMA ,i.name as CONSTRAINT_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,col.name as COLUMN_NAME ,col.colid as ORDINAL_POSITION from sysobjects c_obj @ ,sysobjects t_obj ,syscolumns col ,master.dbo.spt_values v ,sysindexes i where c_obj.uid = user_id() and c_obj.xtype in ('UQ' ,'PK') and t_obj.id = c_obj.parent_obj and t_obj.xtype = 'U' and t_obj.id = col.id and col.name = index_c@ol(t_obj.name,i.indid,v.number) and t_obj.id = i.id and c_obj.name = i.name and v.number > 0 and v.number <= i.keycnt and v.type = 'P' Pj  jPj j Pj H +Pj j 4\o3\́CR0x(8LdPjX0s@&o3 grrevLs1 [Y` Ps j 4s&o3sdR0L0XP>DFtD c\(AU5Ido3.REFERENTIAL_CONSTRAINTStO6S0&USCONSTRAINT_CATALOGH/o3SplitNextDt jY/`Lt $@FULtUN TLtN\TUPt sLt T\bNUt Uth(JDH&(*$($4.2.4**$((,*$(@<:482,0,&"4,&*&2>*0*@(&,&**$(&(,*$(@<:482,0"4,,&*2>*4.2,&*4*&4.20x6:sstatus6^tactions6^tcolid6^tconstid6^terror6^tid6^tspare16^tstatus6ualtsuid6usuid6Xv(CATALOG_NAME6XvJDEFAULT_CHARACTER_SET_CATALOG6XvDDE@AULT_CHARACTER_SET_NAME6XvHDEFAULT_CHARACTER_SET_SCHEMA6Xv&SCHEMA_NAME6Xv(SCHEMA_OWNER6˿w*TABLE_CATALOG6˿w$TABLE_NAME6˿w(TABLE_SCHEMA6˿w$TABLE_TYPE6x4CONSTRAINT_CATALOG6x.CONSTRAINT_NAME6x2CONSTRAINT_SCHEMA6@.CONSTRAINT_TYPE6x 4INITIALLY_DEFERRED6x*IS_DEFERRABLE6x*TABLE_CATALOG6x$TABLE_NAME6x(TABLE_SCHEMA6yGRANTEE6yGRANTOR6y(IS_GRANTABLE6y,PRIVILEGE_TYPE6y*TABLE_CATALOG6y$TABLE_NAME6y(TABL@_SCHEMA6<8z @CHARACTER_MAXIMUM_LENGTH6<8z <CHARACTER_OCTET_LENGTH6<8z:CHARACTER_SET_CATALOG6<8z4CHARACTER_SET_NAME6<8z8CHARACTER_SET_SCHEMA6<8z2COLLATION_CATALOG6<8z,COLLATION_NAME6<8z0COLLATION_SCHEMA6<8z,COLUMN_DEFAULT6<8z&@OLUMN_NAME6<8z"DATA_TYPE6<8z4DATETIME_PRECISION6<8z,DOMAIN_CATALOG6<8z&DOMAIN_NAME6<8z*DOMAIN_SCHEMA6<8z&IS_NULLABLE6<8z 2NUMERIC_PRECISION6<8z >NUMERIC_PRECISION_RADIX6<8z *NUMERIC_SCALE6<8z0ORDINAL_POSITION6<8z*TABL@_CATALOG6<8z$TABLE_NAME6<8z(TABLE_SCHEMA6u\{&COLUMN_NAME6u\{,DOMAIN_CATALOG6u\{&DOMAIN_NAME6u\{*DOMAIN_SCHEMA6u\{*TABLE_CATALOG6u\{$TABLE_NAME6u\{(TABLE_SCHEMA6|&COLUMN_NAME6|GRANTEE6|GRANTOR6|(IS_G@ANTABLE6|,PRIVILEGE_TYPE6|*TABLE_CATALOG6|$TABLE_NAME6|(TABLE_SCHEMA6x}@CHARACTER_MAXIMUM_LENGTH6x}<CHARACTER_OCTET_LENGTH6x} :CHARACTER_SET_CATALOG6x} 4CHARACTER_SET_NAME6x} 8CHARACTER_SET_SCHEMA6x}2COLLATION_CA@ALOG6x} ,COLLATION_NAME6x}0COLLATION_SCHEMA6x}"DATA_TYPE6x}4DATETIME_PRECISION6x},DOMAIN_CATALOG6x},DOMAIN_DEFAULT6x}&DOMAIN_NAME6x}*DOMAIN_SCHEMA6x} 2NUMERIC_PRECISION6x}>NUMERIC_PRECISION_RADIX6x}*NUMERIC_@CALE6 l~4CONSTRAINT_CATALOG6 l~.CONSTRAINT_NAME6 l~2CONSTRAINT_SCHEMA6 l~,DOMAIN_CATALOG6 l~&DOMAIN_NAME6 l~*DOMAIN_SCHEMA6 l~4INITIALLY_DEFERRED6 l~*IS_DEFERRABLE6Y`&COLUMN_NAME6Y`4CONSTRAINT_CATALOG6Y`.CONSTRAI@T_NAME6Y`2CONSTRAINT_SCHEMA6Y`0ORDINAL_POSITION<t NhtUhp8Xt #\ 6:sU statusPt t 4to3tR0hltNft 46U4CONSTRAINT_CATALOG@OtQ0&UQCONSTRAINT_SCHEMAltNgt26U2CONSTRAINT_SCHEMAtOtM0&UMCONSTRAINT_NAMEhtNgt.6U.CONSTRAINT_NAMEtO@ta0&UaUNIQUE_CONSTRAINT_CATALOG|tNitB6UBUNIQUE_CONSTRAINT_CATALOGtO t_0&U_UNIQUE_CONSTRAINT_SCHEMAxtNjt@6U@UNIQUE_CONSTRAINT_SC@EMAtO!t[0&U[UNIQUE_CONSTRAINT_NAMEttNjt<6U<UNIQUE_CONSTRAINT_NAMEtO"tG0&UGMATCH_OPTION`tNit(6U(MATCH_OPTIONt@O#tE0&U EUPDATE_RULE`tNmt&6U&UPDATE_RULEtO$tE0&U EDELETE_RULE`tNit&6U &DELETE_RULEPt ; \:U@Pt!; t!UPt"; t"UPt#; t#UPt$; t$UPt%; t%UPt&; t&UPt';@t'UPt(; t(UPt); t)U t*U4t+\<`0*UV  o3 `REFERENTIAL_CONSTRAINTStt,\=<6U<REFERENTIAL_CONSTRAINTSD@t-!\> UH/o3SplitNextDt/ t]/@Lt0YPQLt1PMQYLt2Q#(PYt3Yt1  0:s@CREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 0^tCREATE VIEW sysconstraints AS SELECT constid = convert(int, id), id = convert(int, parent_obj), colid = convert(smallint, info), spare1 = convert(tinyint, 0), status = convert(int, CASE xtype WHEN 'PK' THEN 1 WHEN 'UQ' THEN 2 WHEN 'F' THEN 3 WHEN 'C' THEN 4 WHEN 'D' THEN 5 ELSE 0 END + CASE WHEN in@o != 0 -- CNST_COLUMN / CNST_TABLE THEN (16) ELSE (32) END + CASE WHEN (status & 16)!=0 -- CNST_CLINDEX THEN (512) ELSE 0 END + CASE WHEN (status & 32)!=0 -- CNST_NCLINDEX THEN (1024) ELSE 0 END + (2048) -- CNST_NOTDEFERRABLE + CASE WHEN (status & 256)!=0 -- CNST_DISABLE THEN (16384) ELSE 0 END + CASE WHEN (status & 512)!=0 -- CNST_ENABLE THEN (32767) ELSE 0 END + CASE WHEN (status & 4)!=0 -- CNST_NONAME THEN (131072) ELSE 0 END + CASE@WHEN (status & 1)!=0 -- CNST_NEW THEN (1048576) ELSE 0 END + CASE WHEN (status & 1024)!=0 -- CNST_REPL THEN (2097152) ELSE 0 END), actions = convert(int, 4096), error = convert(int, 0) FROM sysobjects WHERE xtype in ('C', 'F', 'PK', 'UQ', 'D') AND (status & 64) = 0 0uCREATE VIEW sysalternates AS SELECT suid = convert(smallint, suser_id(substring(name, 2, 63))), altsuid = convert(smallint, suser_id(suser_sname(user_sid(altuid)))) FROM sysusers W@ERE isaliased = 1 0Xv  --Identifies schmata owned by current users, databases current users has permissions in create view INFORMATION_SCHEMA.SCHEMATA as select db.name as CATALOG_NAME ,USER_NAME() as SCHEMA_NAME ,USER_NAME() as SCHEMA_OWNER ,'master' as DEFAULT_CHARACTER_SET_CATALOG ,'dbo' as DEFAULT_CHARACTER_SET_SCHEMA ,a_cha.name as DEFAULT_CHARACTER_SET_NAME FROM master.dbo.sysdatabases db, master.dbo.sysconfigures cfg, master.dbo.syscharsets a_cha, @-charset/1001, not sortorder. master.dbo.syscharsets b_cha --sortorder/2001, not charset. WHERE cfg.comment = 'default sortorder id' AND a_cha.type = 1001 --- type is charset AND b_cha.type = 2001 --- type is sortorder AND a_cha.id = b_cha.csid AND b_cha.id = cfg.value 0˿w--Identifies tables accessible to the current user create view INFORMATION_SCHEMA.TABLES as select distinct db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_N@ME ,case o.xtype when 'U' then 'BASE TABLE' when 'V' then 'VIEW' end as TABLE_TYPE from sysobjects o where o.xtype in ('U', 'V') and permissions(o.id) != 0 0x--Identifies table constraints owned by current users create view INFORMATION_SCHEMA.TABLE_CONSTRAINTS as select db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA @t_obj.name as TABLE_NAME ,case c_obj.xtype when 'C' then 'CHECK' when 'UQ' then 'UNIQUE' when 'PK' then 'PRIMARY KEY' when 'F' then 'FOREIGN KEY' end as CONSTRAINT_TYPE ,'NO' as IS_DEFERRABLE ,'NO' as INITIALLY_DEFERRED from sysobjects c_obj ,sysobjects t_obj where c_obj.uid = user_id() and t_obj.id = c_obj.parent_obj and c_obj.xtype in ('C' ,'UQ' ,'PK' ,'F') 0y --Identifies privileges granted @to or by the current user create view INFORMATION_SCHEMA.TABLE_PRIVILEGES as select user_name(p.grantor) as GRANTOR ,user_name(p.uid) as GRANTEE ,db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME ,@case p.action when 26 then 'REFERENCES' when 193 then 'SELECT' when 195 then 'INSERT' when 196 then 'DELETE' when 197 then 'UPDATE' end as PRIVILEGE_TYPE ,case when p.protecttype = 205 then 'NO' else 'YES' end as IS@_GRANTABLE from sysprotects p, sysobjects o where (is_member(user_name(p.uid)) = 1 or p.grantor = user_id()) and (p.protecttype = 204 or /*grant exists without same grant with grant */ (p.protecttype = 205 and not exists(select *@ from sysprotects p2 where p2.id = p.id and p2.uid = p.uid and p2.action = p.action and p2.columns = p.columns and p2.grantor = p.grantor and p2.protecttype = 204))) and p.action in (26,193,195,196,197) and p.id = o.id@ and o.xtype in ('U', 'V') and 0 != (permissions(o.id) & case p.action when 26 then 4 /*REFERENCES basebit on all columns */ when 193 then 1 /*SELECT basebit on all columns */ when 195 then 8 /*INSERT basebit */ when 196 @then 16 /*DELETE basebit */ when 197 then 2 /*UPDATE basebit on all columns */ end) <t4 Pt2Yp8Lt50jUYPt6  t4t/o3t/R0,t.Yt4@0U --Identifies foreign constraints owned by current user. create view INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS as select db_name() as CONSTRAINT_CATALOG ,user_name(fc_obj.uid) as CONSTRAINT_SCHEMA ,fc_obj.name as CONSTRAINT_NAME ,db_name() as UNIQUE_CONSTRAINT_CATALOG ,user_name(pc_obj.uid) as UNIQUE_CONSTRAINT_SCHEMA ,i.name as UNIQUE_CONSTRAINT_NAME ,'PARTIAL' as MATCH_OPTION ,'NO ACTION' as UPDATE_RULE ,'NO ACTION' as DELETE_RULE f@om sysobjects fc_obj ,sysreferences r ,sysindexes i ,sysobjects pc_obj where fc_obj.uid = user_id() and fc_obj.xtype = 'F' and r.constid = fc_obj.id and r.rkeyid = i.id and r.rkeyindid = i.indid and r.rkeyid = pc_obj.id Pt9  t7Pt: t:Pt; t; Pt< Ht< 4to3t́CR0%d%%$$@$##"""0"!!@! P Pp|xXtX p$L\r,A-H f HtNSTRECExF$\X0F@p3 grrevL1 sU P t= 4p3dR0q0XP( D ct(A5IZ=Xp3"CHECK_CONSTRAINTSO%tS0&5ISCONSTRAINT_CATALOGlNot 465I4CONSTRAINT_CATALOGO&Q0&5I@QCONSTRAINT_SCHEMAlNp265I2CONSTRAINT_SCHEMAO'M0&5IMCONSTRAINT_NAMEhNp.65I.CONSTRAINT_NAMEO(G0&5I@GCHE@CK_CLAUSE` No(65I(CHECK_CLAUSEP ; t*5IP ;  5IP ;  5IP ;  5IP; 5I @P; 5I 5It,T0*5IV p3 TCHECK_CONSTRAINTSht-065I0CHECK_CONSTRAINTSD!t. 5IYt905I --Ide@tifies check constraints owned by current user create view INFORMATION_SCHEMA.CHECK_CONSTRAINTS as select db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME ,com.text as CHECK_CLAUSE from sysobjects c_obj ,syscomments com where c_obj.uid = user_id() and c_obj.id = com.id and c_obj.xtype = 'C' P  P HP  P 4p3́CR0 p htTdt,8@\nX0 @p3 grrevL1 5I P  4p3dR0M0XP> D c(AZ==~1`~q3,CONSTRAINT_TABLE_USAGEO) I0&Z=ITABLE_CATALOGdNs *6Z=*TABLE_CATALOGO*G0&Z=@GTABLE_SCHEMA`Nt(6Z=(TABLE_SCHEMA|O+C0&Z=CTABLE_NAME\Nt$6Z=$TABLE_NAMEO,S0&Z=SCONSTRAINT_CATALOGl @s46Z=4CONSTRAINT_CATALOG O- Q0&Z=QCONSTRAINT_SCHEMAl Nt 26Z=2CONSTRAINT_SCHEMA O. M0&Z=MCONSTRAINT_NAMEh Nt@.6Z=.CONSTRAINT_NAMEP; Z= P; Z=P; Z=P; Z=P; Z= Z=4@^0*Z=V ~q3 ^CONSTRAINT_TABLE_USAGEt:6Z=:CONSTRAINT_TABLE_USAGED! Z=TY0Z= --Identifies tables owned by the current user the have constraints create view INFORMATION_SCHEMA.CONSTRAINT_TABLE_@SAGE as select db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME from sysobjects c_obj ,sysobjects t_obj where t_obj.uid = user_id() and t_obj.id = c_obj.parent_obj and c_obj.xtype in ('C' ,'UQ' ,'PK' ,'F') P  P HP  P 4~q3́CR0 0 < |,<LT\$@\U NX0@q3 grrevL1 Z= P  4q3dR0=0XP7Z-.D c(A=~1v%dir3.CONSTRAINT_COLUMN_USAGEO/ I0&=~1ITABLE_CATALOGdNy*6=~1*TABLE_CATALOGO0G0&=~1@GTABLE_SCHEMA`Nz(6=~1(TABLE_SCHEMA|O1C0&=~1CTABLE_NAME\Nz$6=~1$TABLE_NAMEO2E0&=~1ECOLUMN_NAME` Ny@&6=~1&COLUMN_NAME O3 S0&=~1SCONSTRAINT_CATALOGl Nz 46=~14CONSTRAINT_CATALOG O4 Q0&=~1QCONSTRAINT_SCHEMAl N{ 26=~1@2CONSTRAINT_SCHEMAO5 M0&=~1MCONSTRAINT_NAMEhN{.6=~1.CONSTRAINT_NAMEP; =~1Y`P; =~1Y`P; =~1@`P; =~1Y`P; =~1Y`P; =~1Y`P; =~1Y`P; =~1P; =~1P@; =~1P; =~1 P; =~1P; =~1P; =~1 P; =~1P; @=~1P ;  =~1P!; !=~1 P"; "=~1 #=~14$`0*=~1V ir3 `CONSTRAINT_COLUMN_USAGEt%<@=~1<CONSTRAINT_COLUMN_USAGED&! =~1H/ir3SplitNextD( t0^/@L)ZYQL*YQZL+Qt3YZ,@Z*  0uCREATE VIEW sysalternates AS SELECT suid = convert(smallint, suser_id(substring(name, 2, 63))), altsuid = convert(smallint, suser_id(suser_sname(user_sid(altuid)))) FROM sysusers WHERE isaliased = 1 0Xv  --Identifies schmata owned by current users, databases current users has permissions in create view INFORMATION_SCHEMA.SCHEMATA as select db.name as CATALOG_NAME ,USER_NAME() as SCHEMA_NAME ,USER_N@ME() as SCHEMA_OWNER ,'master' as DEFAULT_CHARACTER_SET_CATALOG ,'dbo' as DEFAULT_CHARACTER_SET_SCHEMA ,a_cha.name as DEFAULT_CHARACTER_SET_NAME FROM master.dbo.sysdatabases db, master.dbo.sysconfigures cfg, master.dbo.syscharsets a_cha, --charset/1001, not sortorder. master.dbo.syscharsets b_cha --sortorder/2001, not charset. WHERE cfg.comment = 'default sortorder id' AND a_cha.type = 1001 --- type is charset AND b_cha.type = 2001 --- type is sortorder AND a_cha.id = b_ch@.csid AND b_cha.id = cfg.value 0˿w--Identifies tables accessible to the current user create view INFORMATION_SCHEMA.TABLES as select distinct db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME ,case o.xtype when 'U' then 'BASE TABLE' when 'V' then 'VIEW' end as TABLE_TYPE from sysobjects o where o.xtype in ('U', 'V') and permissions(o.id) != 0 0x--Identifies table constraints owned by current use@s create view INFORMATION_SCHEMA.TABLE_CONSTRAINTS as select db_name() as CONSTRAINT_CATALOG ,user_name(c_obj.uid) as CONSTRAINT_SCHEMA ,c_obj.name as CONSTRAINT_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,case c_obj.xtype when 'C' then 'CHECK' when 'UQ' then 'UNIQUE' when 'PK' then 'PRIMARY KEY' when 'F' then 'FOREIGN KEY' end as CONSTRAINT_TYPE ,'NO' as IS_DEFERRABLE ,'NO' as @NITIALLY_DEFERRED from sysobjects c_obj ,sysobjects t_obj where c_obj.uid = user_id() and t_obj.id = c_obj.parent_obj and c_obj.xtype in ('C' ,'UQ' ,'PK' ,'F') 0y --Identifies privileges granted to or by the current user create view INFORMATION_SCHEMA.TABLE_PRIVILEGES as select user_name(p.grantor) as GRANTOR ,@user_name(p.uid) as GRANTEE ,db_name() as TABLE_CATALOG ,user_name(o.uid) as TABLE_SCHEMA ,o.name as TABLE_NAME ,case p.action when 26 then 'REFERENCES' when 193 then 'SELECT' when 195 then 'INSERT' when 196 then 'DELETE' @ when 197 then 'UPDATE' end as PRIVILEGE_TYPE ,case when p.protecttype = 205 then 'NO' else 'YES' end as IS_GRANTABLE from sysprotects p, sysobjects o where (is_member(user_name(p.uid)) = 1 or p.grantor = user_id())@ and (p.protecttype = 204 or /*grant exists without same grant with grant */ (p.protecttype = 205 and not exists(select * from sysprotects p2 where p2.id = p.id and p2.uid = p.uid and p2.action = p.action and p2.columns = p.c@olumns and p2.grantor = p.grantor and p2.protecttype = 204))) and p.action in (26,193,195,196,197) and p.id = o.id and o.xtype in ('U', 'V') and 0 != (permissions(o.id) & case p.action when 26 then 4 /*REFERENCES basebit on a@ll columns */ when 193 then 1 /*SELECT basebit on all columns */ when 195 then 8 /*INSERT basebit */ when 196 then 16 /*DELETE basebit */ when 197 then 2 /*UPDATE basebit on all columns */ end) <- Y+Z@p8L.0t6uZP/  4(ir3(R0'Y.l0=~1l --Identifies tables and columns owned by the current user the have constraints create view INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ( TABLE_CATALOG ,TABLE_SCHEMA ,TABLE_NAME ,COLUMN_NAME ,CONSTRAINT_CATALOG ,CO@STRAINT_SCHEMA ,CONSTRAINT_NAME ) as select KCU.TABLE_CATALOG /*TABLE_CATALOG*/ ,KCU.TABLE_SCHEMA /*TABLE_SCHEMA*/ ,KCU.TABLE_NAME /*TABLE_NAME*/ ,KCU.COLUMN_NAME /*COLUMN_NAME*/ ,KCU.CONSTRAINT_CATALOG/*CONSTRAINT_CATALOG*/ ,KCU.CONSTRAINT_SCHEMA /*CONSTRAINT_SCHEMA*/ ,KCU.CONSTRAINT_NAME /*CONSTRAINT_NAME*/ from INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU UNION select db_name() /*TABLE_CATALOG*/ ,user_name(t_obj.uid)/*TABLE_SCHEMA*/ ,t_obj.name /*TABLE_NAME*/ ,cols.@ame /*COLUMN_NAME*/ ,db_name() /*CONSTRAINT_CATALOG*/ ,user_name(c_obj.uid)/*CONSTRAINT_SCHEMA*/ ,c_obj.name /*CONSTRAINT_NAME*/ from sysobjects t_obj ,sysobjects c_obj ,syscolumns cols where t_obj.uid = user_id() and t_obj.id = c_obj.parent_obj and c_obj.xtype = 'C' and c_obj.info = cols.colid and cols.id = c_obj.parent_obj UNION select db_name() /*TABLE_CATALOG*/ ,user_name(t_obj.uid) /*TABLE_SCHEMA*/ ,t_obj.name /*TABLE_NAME*/ ,col.name /*COLUMN_NAME*/ ,db@name() /*CONSTRAINT_CATALOG*/ ,user_name(r_obj.uid) /*CONSTRAINT_SCHEMA*/ ,r_obj.name /*CONSTRAINT_NAME*/ FROM sysobjects t_obj ,syscolumns col ,systypes typ ,sysobjects r_obj WHERE t_obj.uid = user_id() AND t_obj.id = col.id AND col.xusertype = typ.xusertype AND typ.xusertype > 256 -- UDF Type AND typ.domain = r_obj.id AND r_obj.xtype = 'R' P2  0P3 3HP4 4 P5 54ir3́CR0,h,,+x+$$P$$#X < 0  p 0 @ P `p 08@`(D\_nNIraA6YX0.@r3 grrevL1 =~1 P 6 4r3dR0L0XP>D c(Av%@@s3 VIEWSO6I0&v%ITABLE_CATALOGdN*6v%*TABLE_CATALOGO7G0&v%GTABLE_SCHEM@A`N(6v%(TABLE_SCHEMA|O8C0&v%CTABLE_NAME\N$6v%$TABLE_NAMEO9M0&v%@MVIEW_DEFINITIONh N.6v%@.VIEW_DEFINITION O: G0&v%GCHECK_OPTION` N (6v%(CHECK_OPTION O; G0&v%GIS_UPDATABLE` N (6v%(IS_UPDATABLEP@;( #v%P;( v%P;* v% P;( v%P;( v%P;( v%P;( @v% v%4t%<0*v%V @s3 <VIEWSP#&6v%VIEWSD!' v%HY20v% -- Displays views accessable to current user create view INFORMATION_SCHEMA.VIEWS as select db_name() @ as TABLE_CATALOG ,user_name(obj.uid) as TABLE_SCHEMA ,obj.name as TABLE_NAME ,case when exists (select * from syscomments com3 where com3.id = obj.id and com3.colid > 1) then NULL else com.text end as VIEW_DEFINITION ,case when exists (select * from syscomments com2 where com2.id = obj.id and CHARINDEX('WITH CHECK OPTION', upper(com2.text)) > 0) then 'CASCADE' else 'NONE' end as CHECK_OPTION ,'NO' as IS_UPDATABLE from sy@objects obj ,syscomments com where permissions(obj.id) != 0 and obj.xtype = 'V' and obj.id = com.id and com.colid = 1 P  P P   P 4@s3́CR0H | , D <|,< ,<d \s X0@s3 grrevL1 v% P  4s3dR0d0XP8 D c(A T!t3 VIEW_TABLE_USAGEO< G0&GVIEW_CATALOG`N(6(VIEW_CATALOGO=E0&EVIEW_@SCHEMA`N&6&VIEW_SCHEMA|O>A0&AVIEW_NAME\N"6"VIEW_NAMEO?I0&ITABLE_CATALOGd N@*6*TABLE_CATALOG O@ G0&GTABLE_SCHEMA` N (6(TABLE_SCHEMA| OA C0&CTABLE_NAME\ N $6$TABLE_NAMEP@/ P;/ P;/ P;1 P;3  P;3   4@R0*V !t3 RVIEW_TABLE_USAGEh#.6.VIEW_TABLE_USAGED! hY/0/ -- Identifies views owned by current user and the tables used in their definition create view INFORMATION_SCHEMA.VIEW_TABLE_USAGE as selec@ distinct db_name() as VIEW_CATALOG ,user_name(v_obj.uid) as VIEW_SCHEMA ,v_obj.name as VIEW_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME from sysobjects t_obj ,sysobjects v_obj ,sysdepends dep where v_obj.uid = user_id() and v_obj.xtype = 'V' and dep.id = v_obj.id and dep.depid = t_obj.id P  P HP   P 4!t3́CR0 x ( tx(80Hp0\t;X0@lt3 grrevL1  P  4lt3dR0]0XP$D c(A !Xu3"VIEW_COLUMN_USAGEOB G0& GVIEW_CATALOG`N(6 (VIEW_CATALOGOCE0& EVIE@W_SCHEMA`N&6 &VIEW_SCHEMA|ODA0& AVIEW_NAME\N"6 "VIEW_NAMEOEI0& ITABLE_CATALOGd N@*6 *TABLE_CATALOG OF G0& GTABLE_SCHEMA` N (6 (TABLE_SCHEMA| OG C0& CTABLE_NAME\ N $6 $TABLE_NAME@OH E0& ECOLUMN_NAME`N&6 &COLUMN_NAMEP;5  P;5  P;5  P;7  @P;9   P;9   P;9   P;9   P;9  P;9   @ 4T0* V u3 TVIEW_COLUMN_USAGEh#06 0VIEW_COLUMN_USAGED!  Y0  -- Identifies views owned by current user and the columns used in their definition create view INFORMATIO@_SCHEMA.VIEW_COLUMN_USAGE as select db_name() as VIEW_CATALOG ,user_name(v_obj.uid) as VIEW_SCHEMA ,v_obj.name as VIEW_NAME ,db_name() as TABLE_CATALOG ,user_name(t_obj.uid) as TABLE_SCHEMA ,t_obj.name as TABLE_NAME ,col.name as COLUMN_NAME from sysobjects t_obj ,sysobjects v_obj ,sysdepends dep ,syscolumns col where v_obj.uid = user_id() and v_obj.xtype = 'V' and dep.id = v_obj.id and dep.depid = t_obj.id and t_obj.id = col.id and dep.depnumber H col.colid P  P  P! ! P" "4u3́CR0P`D L \ ll4Lt4\=NX0@Mu3 grrevL1   P # 4Mu3dR0_0XXz`3XG3nq Xz`3X3 8q Xz`\3Xa3q P @uq3 Ghost8 8 8  8  8  8 8 8 H8  4 c)dl4q3//Pp8XXz`8d4XFd4fq Xz`4X4fq Xz`'4X+4 8q Xz`3M7X8M7 8q X`a7D c$@xXo7q Xz`7X7n8q Xz`J7XO7 8q X @/7 GhostD c 4 c0`h47w8CXXz`K7XZ7q