Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Troubles..


  • Please log in to reply
2 replies to this topic

#1 DevilsKnight

DevilsKnight

  • Members
  • 3 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:10:59 AM

Posted 18 June 2011 - 03:50 PM

Usrlogon.cmd


@Echo Off

Call "%SystemRoot%\Application Compatibility Scripts\SetPaths.Cmd"
If "%_SETPATHS%" == "FAIL" Goto Done

Rem
Rem This is for those scripts that don't need the RootDrive.
Rem

If Not Exist "%SystemRoot%\System32\Usrlogn1.cmd" Goto cont0
Cd /d "%SystemRoot%\Application Compatibility Scripts\Logon"
Call "%SystemRoot%\System32\Usrlogn1.cmd"

:cont0

Rem
Rem Determine the user's home directory drive letter. If this isn't
Rem set, exit.
Rem

Cd /d %SystemRoot%\"Application Compatibility Scripts"
Call RootDrv.Cmd
If "A%RootDrive%A" == "AA" End.Cmd

Rem
Rem Map the User's Home Directory to a Drive Letter
Rem

Net Use %RootDrive% /D >NUL: 2>&1
Subst %RootDrive% "%HomeDrive%%HomePath%"
if ERRORLEVEL 1 goto SubstErr
goto AfterSubst
:SubstErr
Subst %RootDrive% /d >NUL: 2>&1
Subst %RootDrive% "%HomeDrive%%HomePath%"
:AfterSubst

Rem
Rem Invoke each Application Script. Application Scripts are automatically
Rem added to UsrLogn2.Cmd when the Installation script is run.
Rem

If Not Exist %SystemRoot%\System32\UsrLogn2.Cmd Goto Cont1

Cd Logon
Call %SystemRoot%\System32\UsrLogn2.Cmd

:Cont1

:Done




MZ   @  !L!This program cannot be run in DOS mode.

$ i-s-s-s|,s|,sRich-s PE L krA ! 
P   @        `           X> P  .rsrc X>  @  @ @.reloc  P  P @ B   H  `  
  p    u       y  |y  }y  ~y 0 y H y ` y x y  y  y  y  t       8  P  h       
! (
" @
# X
$ p
&
'
(
F
G
J P  z 0 { H | ` } x ~  x 8 y P | h ~       
 (
 @
 X
 p





     0  H  `  x         -  @  S  T 8 Y P Z h e  f  l  m         (  @  X  p     .  l  m  n  o   0  H  `  x          8 P h        ( @ X p     X (*         0  H  `  x              e 8 f P g h h  i  j  k  l  m  n  p ( q @ r X s p t  u  v  w  x  y  z  { 0 | H } ` ~ x         8 P h        ( @ X p        0 H ` x        8 P h         u (   @   X   h   x                                 (   8   H   X   h   x                                 (   8   H   X   h   x                                 (   8   H   X   h   x                                 (   8   H   X   h   x                   !   !   (!   8!   H!   X!   h!   x!   !   !   !   !   !   !   !   !   "   "   ("   8"   H"   X"   h"   x"   "   "   "   "   "   "   "   "   #   #   (#   8#   H#   X#   h#   x#   #   #   #   #   #   #   #   #   $   $   ($   8$   H$   X$   h$   x$   $   $   $   $   $   $   $   $   %   %   (%   8%   H%   X%   h%   x%   %   %   %   %   %   %   %   %   &   &   (&   8&   H&   X&   h&   x&   &   &   &   &   &   &   &   &   '   '   ('   8'   H'   X'   h'   x'   '   '   '   '   '   '   '   '   (   (   ((   8(   H(   X(   h(   x(   (   (   (   (   (   (   (   (   )   )   ()   8)   H)   X)   h)   x)   )   )   )   )   )   )   )   )   *   * T $5 O 0 P  0  r  ^ V       @ 4 0 X  ȹ p 8    P b ` h L г  h X X * ( ( `  ( r  < 8 j X 8  6 P , H H H 4  4 H \  \ x H H  4 @ ( \ \ 4 4 X p H  H X H \ 4 8 4 p 4 \  \ h H 4 4 4 X p 4 H H 4 4 \  4 P H H H ( p 4 4  4 @ H 4 4 4 0 4 h 4 4 H 4 X 4 \ 4 ( 4 ` ;  x>  E  H     #  H   V   *    1 h H9  X   |   `B  pC ~ I  K F (  B } `C  C  C  C  C  D * 0D * `D & D , D < D + (E ; hE 9 E  E  F  8F ( `F $ F  F ' F " F  G " 0G  HG  `G  xG  G G  E  E  G  H  H  8H  PH  pH  H  H  H  H  H  H  H  I  (I
8I  PI  hI  I  I  I  I  I  hJ  J + J - J K ! K $ K = L # J ) 8L  XL # L ! L  L  L / M  8M XM `O  O  O  xM N N @J $ I ( G  G  = E ? 3 @@ < A @B S " @: |
D L G I N C L U D E |4 V S _ V E R S I O N _ I N F O   U  ]U  ]      S t r i n g F i l e I n f o   0 4 0 9 0 4 B 0 L   C o m p a n y N a m e M i c r o s o f t C o r p o r a t i o n j !  F i l e D e s c r i p t i o n M i c r o s o f t S Q L S e r v e r O D B C D r i v e r x ,  F i l e V e r s i o n 2 0 0 0 . 0 8 5 . 1 1 1 7 . 0 0 ( x p s p _ s p 2 _ r t m . 0 4 0 8 0 3 - 2 1 5 8 ) 2  I n t e r n a l N a m e S Q L S R V 3 2 | ,  L e g a l C o p y r i g h t C o p y r i g h t M i c r o s o f t C o r p o r a t i o n 1 9 9 0 - 2 0 0 0 :  O r i g i n a l F i l e n a m e S Q L S R V 3 2 J   P r o d u c t N a m e M i c r o s o f t S Q L S e r v e r 8
 P r o d u c t V e r s i o n 3 . 8 5 . 1 1 1 7 D  V a r F i l e I n f o $  T r a n s l a t i o n  exec sp_server_info 1 exec sp_server_info 2 exec sp_server_info 500 select 501,NULL,1 where 'a'='A' select 504,c.name,c.description,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=123 and f.value=c1.id and c1.csid=c.id set textsize 2147483647 set arithabort on exec sp_server_info 500 select 501,NULL,1 where 'a'='A' select 504,c.name,c.description,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=1123 and f.value=c1.id and c1.csid=c.id set textsize 2147483647 set ansi_null_dflt_on on set arithabort on exec sp_server_info 500 select 501,NULL,1 where 'a'='A' select 504,c.name,c.description,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=1123 and f.value=c1.id and c1.csid=c.id set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off select 504,c.name,c.description,c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config=1123 and f.value=c1.id and c1.csid=c.id select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) l e f t , o u t e r  j o i n  o n  W H E R E w h e r e  A N D ( r i g h t ,  * =  = *  A N D + -' 'YEAR ( ) + -' 'MONTH ( ) + -' 'DAY ( ) + -' 'HOUR ( ) + -' 'MINUTE ( ) + -' .'SECOND (
, , ) + -' -'YEAR ( )TOMONTH + -' 'DAY ( )TOHOUR + -' :'DAY ( )TOMINUTE + -' :: .'DAY ( )TOSECOND ( ) + -' :'HOUR ( )TOMINUTE + -' :: .'HOUR ( )TOSECOND ( ) + -' : .'MINUTE ( )TOSECOND ( ) convert(
,
) ascii(
) char(
) concat(
,+
) 
difference(
,
) insertstuff(
,
,
,
) left substring(
,,1,
) ltrim(
) lengthdatalength(rtrim(
))) locate charindex(
,
) lcaselower(
) repeat replicate(
,
) right(
,
) rtrim(
) soundex(
) space(
)  substring(
,
,
) ucaseupper(
) lower(
) upper(
) abs(
) acos(
) asin(
) atan(
) atan2atn2(
,
) ceiling(
) cos(
) cot(
) degrees(
) exp(
) floor(
) log(
) log10(
) mod(
,%
) pi() power(
,
) radians(
) rand( ) round(
,
) sign(
) sin(
) sqrt(
) tan(
) 
bit_length (datalength(
))*8) extractdatepart( from,
)  octet_length
datalength(
) nowgetdate()  timestampadddateadd(
,
,
) 
timestampdiffdatediff(
,
,
) curdatesubstring(convert(varchar,getdate(),112),1,4)+'-'+substring(convert(varchar,getdate(),112),5,2)+'-'+right(convert(varchar,getdate(),111),2() dayname datename(dw,(
) 
dayofmonth datepart(dd,(
)  dayofweek(((datepart(dw,(
))+@@datefirst-1)%7)+1)  dayofyear datepart(dy,(
) month datepart(mm,(
)  monthname datename(mm,(
) quarter datepart(qq,(
) week datepart(wk,(
) year datepart(yy,(
) curtimeconvert(varchar,getdate(),8)() hour datepart(hh,(
) minute datepart(mi,(
) second datepart(ss,(
) current_timestampconvert(datetime, (
getdate())9substring(substring(convert(varchar,getdate(),113),1,21+(  ) ))+'000',1,24))  current_datesubstring(convert(varchar,getdate(),112),1,4)+'-'+substring(convert(varchar,getdate(),112),5,2)+'-'+right(convert(varchar,getdate(),111),2()  current_time:substring(convert(varchar,getdate(),8),1,8)+'.'+substring( (#convert(varchar,getdate(),14),10,3)9substring(convert(varchar,getdate(),14),10,3)+'000000',1,  ) user USER_NAME() databaseDB_NAME() ifnullisnull(
,
) ( @    ? ? ? ? 0 @ 
V
V
  @ ?<|r qx |; < $ ` ?       ? ? ? ? ? ? ? < 0 `      ( @    ffffffxwfffffffxwwwwwfffffffxwfffffffxwfffffffẍwfffffffxwfffffffxwwwwfffffffxxwfffffffxψwfffffffxxwfffffffxȈwfffffffwfffffffs333333wfffffffxwfffffffxwxwfff` fxxwff`w' xwffrrxwwwwwxwf`hhg''xxwf`wrrxwfx''xwfw~rrxf'''Ljfrrrwwwwwwwf''''fffff rrpwfffff`''' ffffffrrwffffff` fffffff` wfffffffff`fffffffff` fffff      0       ( u   4   ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` ffffffffffffffffffffffffffffffffffffffffffffffffffffffffff` fffffffffffffffp ffffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwwwwwwxfffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwwwwwwxfffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwwwwwwxffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwwwwwwxffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwwwwwwxffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwwwwwwxffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwww wxffffffffffffffffffff` fffffffffffffffwwwwwwwwwwwwwwxffffffffffffffffffff` fffffffffffffff"'wwwwwwwwwwwwwwwwwxffffffffffffffffffff` fffffffffffffff*wwwwwwwwwwwwwwwwwxffffffffffffffffffff` ffgfffgffgfwvgf*wwwwwwwwwwwwwwwwwxffffvffffvwvgvvfffvg` vfvfffwgffvvgfgfgfgffwfgffffffgvvff` vfgffffwfffgfffxxfgvfffvffvfffgfffffg` ffffvfgffffgfgffgh fvffffffvffgffvffgff` fvvfffvvwfffvfffg  pffvgvgffffvfffffgffg` wffggffggfvffvffh ffffffvfffvgffffgvgf` ffgfvffffggffwffxfgfffffvffffffvgvvfff` wffwvgfffgfgvggfxvvfgvfffffgfffvffgfff` fffffvffvffggvgfx ȏffffffgvfvfffgggffvff` gffgvvffgffwfffvh ȏffvvffffgfffvfffffffv` ffffvwfffffffgfvh ȏgfggvffgfffffvfffffgf` ffwfvvfwffgvvvvfh ȏffvfvvvwvfgfgffvfgvvf` ffffgfvfvffwfvgwh ȏffffffgvffvfvffgfggff` fvfgfvvgfffffvfgx ȏvfffffvgffffvffffvfff` ffgggvgfffffffffh ȏwvgfwgfvffwfvfvfvgffp gvfwggfvvwfffgffh ȏwwxfgvfgfgvvffgvfvfff` gfvvfgvgfffffffgh ȏwwwwxffgfgwfffffggfff` gfffgffvgfvgffgvx ȏwwwwwwxwgfgffffvfffvf` fffgwfgfffwffgvfh ȏwwwwwwwwxffvgfffvvvvfp ffvfffffggggffffh ȏwwwwwwwwwwvvggfffggffp fvffvfffvfvfffvfh ȏwwwwwwwwwwwwgfffvvvf` fvfvvffgfffwffffh ȏwwwwwwwwwwwwwwgfffff` wffvgffvwgfgvfffx ȏwwwwwwwwwwwwwwwwffff` ffgvffffffffgfffh ȏwwwwwwwwwwwwwwwwwxffg` fffwwfgfffffggwfh ȏwwwwwwwwwwwwwwwwwwwwv` fwwfffvffffwfffgh ȏwwwwwwwwwwwwwwwwwwwwwp fwvgfffggffgfgffx ȏwwwwwwwwwwwwwwwwwwwwwp gfvfggfggfffgfgvh ȏwwwwwwwwwwwwwwwwwwwwwp vvfffffgffgffgffx ȏwwwwwwwwwwwwwwwwwwwwwp ggfwfgwggfwfffvvh ȏwwwwwwwwwwwwwwwwwwwwwp ffffgfgfwffgfgvfx wwwwwwwwwwwwwwwwwwwwwp gfvfvfvvfffffffvx wwwwwwwwwwwwwwwwwwwp wvvgfffffffffvfvh wwwwwwwwwwwwwwwwwp vfvvfgfffggfffffx wwwwwwwwwwwwwwwp vgfwfwfwgffggwffw wwwwwwwwwwwwwp gffffffffffffffffwwwwwwwwwwwwwwwwwwwxx wwwwwwwwwwwp vvvfgvwffffvvffvfhwww wwwwwwwwwp wvvgvgvfvfgfvfgfvfvffvffvnw wwwwwwww wwwwwwwwp ffffgggffgffvfffgffgwvgvfnxww wwwwwwww wwwwwwwp fgwgfvvffffwfvffggffvvgfgnwxwp wwwwwwwwwx wwwwwp fffvvgvgffvgfgffgwffwfwfg~wxwx wxwwwwwwwwwx wwwp gwgfvffvfffvfffwfffggvvfvxpwww wwxwwwwwwwwwww wp wgffffffwfffgfffffffvggffhwwwwwxwwwwwwwwwwwww w vwfvvfgvfffgvffvfffgfffffhwwwwwpwwwwwwwwwwwwwwwwx  fffffffgfgffffvffvgfffgvfwwwwpwwwwwwwwwwwwwwwwwx fgfvvvfgvgfvwffggvffvfwgfwwwwwwwwwwwwwwwwwwwwwwx fwgvfvvfffffffggffwvgwvwfwwwwwwwwwwwwwwwwwwwwwwp fvffffffvfvwfvfggfffgvvfgwwwwwwwwwwwwwwwwwwwwwp gffwffvfvffvffgfggfvfwvfh~wwwwwwwwwwwwwwwwwwwp ffwfffvffffffgfvgvggfwgfh~Dwwwwwwwwwwwwwwwwwp vfvvgfffvvvvffvgfvwwfggvh~DDDOwwwwwwwwwwwwwwwwwp ffffffvvgvffvfffwfwfgvffh~DDDDDDOwwwwwwwwwwwwwwwp gvgggffffgfvfffgvvgggvwvxDDDDDDDDwwwwwwwwwwwp fgwfvfvvfgfgwfgfffffvwgfxDDDDDDDDDDwwwwwwwwwwwp vffgvffffggffgffvfffvfvg~DHxDDDDDDDDwwwwwwwwp fvvfgfwfffffvgfgfvffggfhw~DODDDDDDDDDOwwwwwwp vffvfwffffvfffffgvvfffgxw~DDDHDDDDDDOwwwwp fwgfffvwffgfvfffgfvfwffxw~DDDtDDDDDDDDwwwp ffgffffffwvgfffffgfvfgfhw~DDxGDDDDDDDww gvffgwfgggvvggffgffffvfw~DHtDGOxDDDDDDDOwwp vfgffgffffffffffwvffwvvw~DGDDHDOOHxDDDDDDDDDOp vffvffwffgfvvfgwvfgfgffw~DGHGDDDDDGxDDDDDDDO ffgvgfgfvffvgfffgffgwfgw~DDODttDDDDDDDDDDDD wvgvffffffvvfffwffgfffhwwxDDDDODDDDDHHDGDDDDDDD vffwgfgfffwffffffvffffhwwDDDDDHwDDDDDDDGHtDDDDDD@ vffffgffffvgwvvfgfffffxwwDDDDHxHDDDDDGGtDDDD@ vffgffffffvfvvvwfwvgvvwwDDDDDGDDDDOxtDDD@ ffffvgfwfgwgggffgfffgfwwwDDDDDDDDDDDOtDDD@ ffvwgfffffvffffggfgfggwxDDDDDDDtDDGODODD fvfffffffffffgffffvfgfwxxxDDDDDODGDO fgvgfffgffvffvffgfwgfxwwxxDDDDDDDDGO gvffvfgffffvwfffgfvgfhwwxDDDDDDDDDHOO vfgffffvgfgvfvfffvffgxww~xpp DDDDDDDDDDDOOp fvgfvfgfvvffffvgfgggfhwwpDDDDDDDDDDO ffvfvvfffgfgffvfvfffgwwpwDDDDDDDDDD gfvvffgwwggfvgvffgffvwxwxwDDDDDDDD@ fgfffvgfvfwfgfvfwfffgp wDDDDDD@ ffvfffwfffggfffffwvwhwwwwx DDDD@ gvwfvffgfgffvfvfgfgghwwwwxwDD@ ffgffgvvffvgffvvfgfgxwwwwx xw@ fgvgffvwvfgvvwfvgfwfxw wxwppp fffgvgvvwvvfffvfffvfwx p gvfffvffffgwfwvwgwfgwp pwp wfffgfffggfwwffvfffgwxx pw w gfwfgvfffgfvgfwfvffxwwxw vfffgwfffgfffgvfgvgxwp  wp ffgggvwvvvfvfvfvwfvxw  xp vfggvwffwvwfvwvfwwvhw  xx ffgwwvvwffwfggffgwgw  p fgfgvggggffvfgvfvfwww p w fvffgvffffffvfvvgvfww  xpp gfgwvfgvfggffvfvffgwx wp wp vgwvvvfvffvfvvffffxwwx0  ww ffffffvfffgfwfggwgxwwx 0 www wfvvfffggfvwgffvfwhww 3 p0wwwxp  vfffffwvfvfgwfwwfvww wwxpp gffffvgvvwffvffvfgww;0 wx  gvggwfgvvvgwgffgwfww  wpp vfgwvggfvvgwfggvffwx ~rww pp gfgwgffvgvgvfgvfghwwx w(((( wwxpp gvfvgwfgvfffggvvghwwx ~~rwwwxpx vgvgvfffgfvffffffxwwp'((wwwwpx gfvvwwgfffgffwfvvhwwp~rwwwwwpx fgvfvvgfgfvvfvfffww(( wwwpp vvgfvvvgvfgfffwvwww wwp wpwp wvwffffwvfvffvvfvwx  pp fgvwgfvvfvgfwgffxwwx xxp gfvffwgvfgfffvffhwwx w ffffgvwgffwfggvghwwxw  wwgwvgfggvfvfffghwwp gffvgwffffffvvvgwwxxp gfgggvvffgffvggfwwpxp gfffwfwgvvvggfvgwwp wvvvwggwfgfvwwfgwxxp fwgffvfwwffvfwvhwwxwp  wwvwvfffffwffvfxwwxpp  vwvwffvgwwwgfgfhwwwxp vfgggfgwvfffwwvwwwwxp wffffggvwwffgfvwwxxwx wvgvffffvgvfwfvww gvgwwgfvvfvvgfgwx  gvvggwfvwvfvggxwwxpw  ffvwfggfgfwggghwwxx gwvfgwwggvfgwghwwxpx vgvvfvvgfwwvgwxwwpwwp gvvwfvfvwgfwwwwwxppw fwvvvggvwvvvfwww pp ffgv` 3330x   vvvg`;;;3333xp vvfvpwwwwwwwwwwww33338  vfvv`wwwwwwwwwwww;;;33333pw vgfv`xxxx33333wxwpw vvfg`xxxx;;;33333px gvgwpxxxx33333pxp vgvv`xxxx;;;33333pw wfffpxxxx33333p wgwg`xxxx;;;33333   vgvfpxxxx33333 x vfvg`xxxx;;;33333x wfgg`xxxx33333 ggff`xxxx;;;33333pwxx p fwwf`xxxx33333xxwxp wffvpxxxx;;;33333w p ffvf`xxxx33333xwp gffv`xxxx;;;33333 wvfv`xxxx33333 vgff`3 333 wfvf` 3330 33p wvgg`wwwwwwwwwwww 3;333 p fgvgpwwwwwww?330xxx gwfwpwwwwwww38p vggv`wwwwwww?3w vvww`wwwwwwwwwwww333xpx wgvfpwwwwwwwwwwww33333338x w vfwf` pxx vgwwppwxwp wvvw`ppxp wfvvpwwwwwwwwwwwwwpxp fwfg`wwwwwwwwwwwwxwpppx wgwwpwwwwwwwwwwwwx fwfwpwwwwwwwwwwwwxxw ggvvpwwwwwwwwp gffg`wwwwwwwwww pp gfwvpwwwwwwwwwx xpx vwgwpwwwwwwwwwwwwwwx wwx fgvw`wwwwwwwwwwwwwwwx pw gfvvpxwpwwwww pxxp vfvg`wwwwwwwwww xwwwwxw gfwv`wwwwwwwwwwpxwww  xpx vgfwpwywwfwwpwwwwx  wvfvpwywwfwwpwwwwwwwwx x wggf`wywwwwx x wwwwwwwwwx  vwvwpwwwwwwwwwwwxx wwwwwwwwww wgwwpwwwww pwwwwwwwwwwwx wfww`wwwwwwwwwwwwwwwwwxwwwwwwwwwwwwwwwp wgggpwwwwwwwwwwwwwwwwwwwwwwww wp wwww`wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwx  gggv`wwwwwwwwwwwwwwwwwwwwwwwwwwwx  vfgvwwwwwwwwwwwwwwwwwwwwwwwwwwwx  vgfgfpwwwwwwwwwww wwwwwwwwwwwwwwwwwwwwwwwwwwx  wfwwwwwx wwwwwwwwwwwwwwwwwwwwwwwwww wvvwvvpwww wwwwwwwwwwwwwwwwwwwwwwwwwww vvvwfwvwwwwx wwwwwwwwwwwwwwwwwwwwwwwwwwp vvgvgvxpwwwwwwx wwwwwwwwwwwwwwwwwwwwwwwwp fvvggwhw wwwwwwwx wwwwwwwwwwwwwwwwwwwwwwp gvvwvvwwxwwwwwwwwwwwwwwwwwww wwwwwwwwwwwwwwwwwwwwp vgfwwgwwpwwxwwwwwwwwwwwwwwwwww wwwwwwwwwwwwwwwwwwp wvggwwwwwwxwwwwwwwwwwwwwwwwwwwx wwwwwwwwwwwwwwwwwp gvgfwwwwxxpxwwwwwwwwwwwwwwwwwwx wwwwwwwwwwwwwwwp gvgvwhwwx pwxwwwwwwwwwwwwwwwwwwwx wwwwwwwwwwwwwp gffvfxwwxwwp ppwpwwwwwwwwwwwwwwwwwww wwwwwwwwwwwp ffggvxwwpwwxppxpwwwwwwwwwwwwwwwwwwx wwwwwwwwwp wfvgfxwwpxwwpwpxwwwwwwwwwwwwwwwwwwwx wwwwwwwp wgwfwwww wwwwxwwwwwwwwwwwwwwwwwwwwwwwwx wwwwwp vgvvvwwwwwwwwwx wwwwwwwwwwwwwwwwwwwwwwww wwwwp vgvvfwwwwwwwwxwwwpwwwwwxwwwwwwwwwwwwwwwwww wwp wvvgvwwwwwwwwxwwwwwwwpwx wwwwwwwwwwwwwwwwww p gfggxwwwwwwwwwwwwwwwwxwwwwppwwwwwwwwwwwwwwwwwx  wvgfxwwwwwwwwwwwwwwwwpwwwpwppwwwwwwwwwwwwwwwwwwx vwfvxwwwwwwwwwwwwwwwwwwwxwwwppwwwwwwwwwwwwwwwwwwwww fgfgwhwwwwwwwwwwwwwwwwwwwwwxxxwwwwwwwwwwwwwwwwwww gggfwfwhwwwwwwwwwwwwwwwwwwwx xxwwwwwwwwwwwwwwwwwp wwvfgfffvwwwwwwwwwwwwwwwwwwwwppxwwwwwwwwwwwwwwwwwp vgggvvvwgghwwwwwwwwwwwwwwwwwxwxpwpp xwxwwwwwwwwwwwwwp vwvfwwvgwgfgxwwwwwwwwwwwwwwwxwwwwxwpwwxwwwwwwwwwwwp vvvfvvgggwgwvgwwwwwwwwwwwwwwwwwwww pwwpxwwwwwwwwwp vvgvvffffwggwwvwwwwwwwwwwwwwwwwwwwwxwwwwwwwwwwwwp RC.H Ȁ  A $ S Q L S e r v e r L o g i n  M S S h e l l D l g P  C ,w D a t a S o u r c e : P J
_  2u B!P J  _ < 5u  P  
-w & U s e T r u s t e d C o n n e c t i o n P  . C  $w & L o g i n I D : P J , _ 6u P  @ C  %w & P a s s w o r d : P J > _ 7u  P  T ^ *w O p t i o n s P c b  &w & D a t a b a s e : C !P o a o 0 :u P w b  'w L a n & g u a g e : C !P o u o 0 ;u P b  (w A p p l i c a t i o n & N a m e : P o o 8u P b  )w & W o r k S t a t i o n I D : P o o 9u  P  2   O K P  2   C a n c e l P + 2  & H e l p P = 2  +w & O p t i o n s > >  Ȑ B  M S S h e l l D l g  P k u PX  T h i s w i z a r d w i l l h e l p y o u c r e a t e a n O D B C d a t a s o u r c e t h a t y o u c a n u s e t o c o n n e c t t o S Q L S e r v e r . PX   W h a t n a m e d o y o u w a n t t o u s e t o r e f e r t o t h e d a t a s o u r c e ? PX ) >  ,w N a & m e : P ' w PX =  H o w d o y o u w a n t t o d e s c r i b e t h e d a t a s o u r c e ? PX J >  & D e s c r i p t i o n : P I w PX _  W h i c h S Q L S e r v e r d o y o u w a n t t o c o n n e c t t o ? PX m >  & S e r v e r : B!P k ] w Ȑ B  M S S h e l l D l g  P k u P X  T h i s w i z a r d w i l l h e l p y o u c r e a t e a n O D B C d a t a s o u r c e t h a t y o u c a n u s e t o c o n n e c t t o S Q L S e r v e r . P X   W h a t n a m e d o y o u w a n t t o u s e t o r e f e r t o t h e d a t a s o u r c e ? P X ) >  ,w N a & m e : P ' w P X =  H o w d o y o u w a n t t o d e s c r i b e t h e d a t a s o u r c e ? P X J >  & D e s c r i p t i o n : P I w P X _  W h i c h S Q L S e r v e r d o y o u w a n t t o c o n n e c t t o ? P X m >  & S e r v e r : B!P k ] w  Ȑ B  M S S h e l l D l g  P P u PX   H o w s h o u l d S Q L S e r v e r v e r i f y t h e a u t h e n t i c i t y o f t h e l o g i n I D ? Pb   w & W i t h W i n d o w s N T a u t h e n t i c a t i o n u s i n g t h e n e t w o r k l o g i n I D . Pb '  w W i t h & S Q L S e r v e r a u t h e n t i c a t i o n u s i n g a l o g i n I D a n d p a s s w o r d e n t e r e d b y t h e u s e r . PX ?  T o c h a n g e t h e n e t w o r k l i b r a r y u s e d t o c o m m u n i c a t e w i t h S Q L S e r v e r , c l i c k C l i e n t C o n f i g u r a t i o n . P T n  w C l i e n & t C o n f i g u r a t i o n . . .  PX c  w & C o n n e c t t o S Q L S e r v e r t o o b t a i n d e f a u l t s e t t i n g s f o r t h e a d d i t i o n a l c o n f i g u r a t i o n o p t i o n s . PX B  w & L o g i n I D : P  w PX B  x & P a s s w o r d : P w Ȑ B  M S S h e l l D l g  P P u P X   H o w s h o u l d S Q L S e r v e r v e r i f y t h e a u t h e n t i c i t y o f t h e l o g i n I D ? P b   w & W i t h W i n d o w s N T a u t h e n t i c a t i o n u s i n g t h e n e t w o r k l o g i n I D . P b '  w W i t h & S Q L S e r v e r a u t h e n t i c a t i o n u s i n g a l o g i n I D a n d p a s s w o r d e n t e r e d b y t h e u s e r . P X ?  T o c h a n g e t h e n e t w o r k l i b r a r y u s e d t o c o m m u n i c a t e w i t h S Q L S e r v e r , c l i c k C l i e n t C o n f i g u r a t i o n . P T n  w C l i e n & t C o n f i g u r a t i o n . . .  P X c  w & C o n n e c t t o S Q L S e r v e r t o o b t a i n d e f a u l t s e t t i n g s f o r t h e a d d i t i o n a l c o n f i g u r a t i o n o p t i o n s . P X B  w & L o g i n I D : P  w P X B  x & P a s s w o r d : P w  Ȑ B  M S S h e l l D l g  P 5 j u  PX 
w C h a n g e t h e & d e f a u l t d a t a b a s e t o : B#Pd
< :u  PX 
x A t t a c & h d a t a b a s e f i l e n a m e : Pd ' w  PX 5  w & C r e a t e t e m p o r a r y s t o r e d p r o c e d u r e s f o r p r e p a r e d S Q L s t a t e m e n t s a n d d r o p t h e s t o r e d p r o c e d u r e s : Ph S
w & O n l y w h e n y o u d i s c o n n e c t . Ph ]  w & W h e n y o u d i s c o n n e c t a n d a s a p p r o p r i a t e w h i l e y o u a r e c o n n e c t e d .  PX o
w & U s e A N S I q u o t e d i d e n t i f i e r s .  PX {
w U s e & A N S I n u l l s , p a d d i n g s a n d w a r n i n g s .  PX  w U s e t h e & f a i l o v e r S Q L S e r v e r i f t h e p r i m a r y S Q L S e r v e r i s n o t a v a i l a b l e . Ȑ B  M S S h e l l D l g  P 5 j u  P X 
w C h a n g e t h e & d e f a u l t d a t a b a s e t o : B#P d
< :u  P X 
x A t t a c & h d a t a b a s e f i l e n a m e : P d ' w  P X 5  w & C r e a t e t e m p o r a r y s t o r e d p r o c e d u r e s f o r p r e p a r e d S Q L s t a t e m e n t s a n d d r o p t h e s t o r e d p r o c e d u r e s : P h S
w & O n l y w h e n y o u d i s c o n n e c t . P h ]  w & W h e n y o u d i s c o n n e c t a n d a s a p p r o p r i a t e w h i l e y o u a r e c o n n e c t e d .  P X o
w & U s e A N S I q u o t e d i d e n t i f i e r s .  P X {
w U s e & A N S I n u l l s , p a d d i n g s a n d w a r n i n g s .  P X  w U s e t h e & f a i l o v e r S Q L S e r v e r i f t h e p r i m a r y S Q L S e r v e r i s n o t a v a i l a b l e .  Ȑ B  M S S h e l l D l g  P P u  PX   w & C h a n g e t h e l a n g u a g e o f S Q L S e r v e r s y s t e m m e s s a g e s t o : C#Pd  < ;u  PX #  w U s e s t r o n g e n c r & y p t i o n f o r d a t a  PX 5
w & P e r f o r m t r a n s l a t i o n f o r c h a r a c t e r d a t a  PX ?  w & U s e r e g i o n a l s e t t i n g s w h e n o u t p u t t i n g c u r r e n c y , n u m b e r s , d a t e s a n d t i m e s .  PX O  w & S a v e l o n g r u n n i n g q u e r i e s t o t h e l o g f i l e : Pd b w Pb 1  w B & r o w s e . . . PX s  & L o n g q u e r y t i m e ( m i l l i s e c o n d s ) : Ps ( w  PX
w L o g & O D B C d r i v e r s t a t i s t i c s t o t h e l o g f i l e : Pd w P 1  w B r o & w s e . . . Ȑ  B  M S S h e l l D l g  P P u  P X   w & C h a n g e t h e l a n g u a g e o f S Q L S e r v e r s y s t e m m e s s a g e s t o : C#P d  < ;u  P X #  w U s e s t r o n g e n c r & y p t i o n f o r d a t a  P X 5
w & P e r f o r m t r a n s l a t i o n f o r c h a r a c t e r d a t a  P X ?  w & U s e r e g i o n a l s e t t i n g s w h e n o u t p u t t i n g c u r r e n c y , n u m b e r s , d a t e s a n d t i m e s .  P X O  w & S a v e l o n g r u n n i n g q u e r i e s t o t h e l o g f i l e : P d b w P b 1  w B & r o w s e . . . P X s  & L o n g q u e r y t i m e ( m i l l i s e c o n d s ) : P s ( w  P X
w L o g & O D B C d r i v e r s t a t i s t i c s t o t h e l o g f i l e : P d w P  1  w B r o & w s e . . . Ȁ  O D B C M i c r o s o f t S Q L S e r v e r S e t u p  M S S h e l l D l g  P    A n e w O D B C d a t a s o u r c e w i l l b e c r e a t e d w i t h t h e f o l l o w i n g c o n f i g u r a t i o n : P   w  P  i  w & T e s t D a t a S o u r c e . . . P (   O K P (   C a n c e l Ȑ  S Q L S e r v e r O D B C D a t a S o u r c e T e s t  M S S h e l l D l g  P   T e s t R e s u l t s P   w  P _ 2   O K  2 0 0 0 . 0 8 5 . 1 1 1 7 . 0 0  C o n n e c t i o n O b j e c t S i z e  C o n n e c t i o n R e a d  C o n n e c t i o n W r i t e  C o n n e c t i o n T r a n s a c t  C o n n e c t i o n W r i t e O O B  C o n n e c t i o n O p e n W  C o n n e c t i o n C l o s e  C o n n e c t i o n C h e c k F o r D a t a  C o n n e c t i o n E r r o r W  C o n n e c t i o n S q l V e r  C o n n e c t i o n O p t i o n  C o n n e c t i o n G e t S v r U s e r  I n i t E n u m S e r v e r s  G e t N e x t E n u m e r a t i o n  C l o s e E n u m S e r v e r s  I n i t S S P I P a c k a g e  T e r m S S P I P a c k a g e I n i t S e s s i o n T e r m S e s s i o n  G e n C l i e n t C o n t e x t  C o n n e c t i o n F l u s h C a c h e  a l t e r  a d d c r e a t e p r o c  s e t i m p l i c i t _ t r a n s a c t i o n s o n  s e t i m p l i c i t _ t r a n s a c t i o n s o f f  s e l e c t  w h e r e
S E T R O W C O U N T  S E T N O _ B R O W S E T A B L E
B E G I N T R A N
S E T T E X T S I Z E  m o n e y  u n i q u e i d e n t i f i e r  n t e x t  n v a r c h a r  c r e a t e  d r o p  S E T P A R S E O N L Y O N  S E T P A R S E O N L Y O F F  S E T N O E X E C O N  S E T N O E X E C O F F  d o u b l e  d a t e  t i m e  d a t e t i m e  v a r c h a r s q l _ v a r i a n t t i m e s t a m p  s y s n a m e
s m a l l m o n e y
s m a l l d a t e t i m e
d r o p p r o c  u s e  i n s e r t  d e l e t e  u p d a t e  f r o m  o r d e r  S E T F M T O N L Y O N  S E T F M T O N L Y O F F
h o l d l o c k L c r e a t e ; d r o p ; s e l e c t ; g r a n t ; r e v o k e ; a l t e r ; t r u n c a t e ; u p d a t e ; r e c o n f i g u r e ; l o a d ; d i s k ;
s t a t i s t i c s  I F @ @ T R A N C O U N T > 0 C O M M I T T R A N I F @ @ T R A N C O U N T > 0 R O L L B A C K T R A N K s e l e c t U S E R _ N A M E ( ) s e l e c t u s e r t y p e , t y p e , n a m e f r o m s y s t y p e s w h e r e u s e r t y p e > =  ' I N T E R V A L % c ' ' % l u ' ' Y E A R ( % u ) '  ' I N T E R V A L % c ' ' % l u ' ' M O N T H ( % u ) '  ' I N T E R V A L % c ' ' % l u ' ' D A Y ( % u ) '  ' I N T E R V A L % c ' ' % l u ' ' H O U R ( % u ) '  ' I N T E R V A L % c ' ' % l u ' ' M I N U T E ( % u ) ' $ ' I N T E R V A L % c ' ' % l u % s ' ' S E C O N D ( % u , % u ) ' , ' I N T E R V A L % c ' ' % l u - % 0 2 l u ' ' Y E A R ( % u ) T O M O N T H ' * ' I N T E R V A L % c ' ' % l u % 0 2 l u ' ' D A Y ( % u ) T O H O U R ' 2 ' I N T E R V A L % c ' ' % l u % 0 2 l u : % 0 2 l u ' ' D A Y ( % u ) T O M I N U T E ' > ' I N T E R V A L % c ' ' % l u % 0 2 l u : % 0 2 l u : % 0 2 l u % s ' ' D A Y ( % u ) T O S E C O N D ( % u ) ' - ' I N T E R V A L % c ' ' % l u : % 0 2 l u ' ' H O U R ( % u ) T O M I N U T E ' 9 ' I N T E R V A L % c ' ' % l u : % 0 2 l u : % 0 2 l u % s ' ' H O U R ( % u ) T O S E C O N D ( % u ) ' 5 ' I N T E R V A L % c ' ' % l u : % 0 2 l u % s ' ' M I N U T E ( % u ) T O S E C O N D ( % u ) '  d b c c t r a c e o n ( 2 0 8 )  s e t q u o t e d _ i d e n t i f i e r > s e t a n s i _ n u l l s o f f s e t a n s i _ p a d d i n g o f f s e t a n s i _ w a r n i n g s o f f s e t c o n c a t _ n u l l _ y i e l d s _ n u l l o f f [ b e g i n d e c l a r e @ n v a r c h a r ( 3 0 ) e x e c s p _ f a l l b a c k _ M S _ s e l _ f b _ s v r @ n o u t p u t s e l e c t 5 0 3 , ' ' , @ n e n d # % 0 4 d - % 0 2 u - % 0 2 u % 0 2 u : % 0 2 u : % 0 2 u . % 0 3 l u  t a b l e s s e l e c t n a m e f r o m m a s t e r . d b o . s y s c h a r s e t s w h e r e i d = c o n v e r t ( t i n y i n t , d a t a b a s e p r o p e r t y e x ( d b _ n a m e ( ) , ' s q l c h a r s e t ' ) ) / S E T T R A N S A C T I O N I S O L A T I O N L E V E L R E P E A T A B L E R E A D  i d e n t i t y , S E T T R A N S A C T I O N I S O L A T I O N L E V E L S E R I A L I Z A B L E c h a r b i n a r y d e c i m a l i n t e g e r s m a l l i n t f l o a t r e a l d o u b l e v a r c h a r d a t e t i m e t i m e s t a m p l o n g v a r c h a r v a r b i n a r y l o n g v a r b i n a r y t i n y i n t b i t n u m e r i c c h a r ( 2 5 5 ) ; b i n a r y ( 2 5 5 ) ; d e c i m a l ( 3 8 , 4 ) ; i n t ; s m a l l i n t ; f l o a t ; r e a l ; f l o a t ; v a r c h a r ( 2 5 5 ) ; d a t e t i m e ; d a t e t i m e ; d a t e t i m e ; t e x t ; v a r b i n a r y ( 2 5 5 ) ; i m a g e ; t i n y i n t ; b i t ; n u m e r i c ( 3 8 , 4 ) ; c h a r ( 2 5 5 ) ; b i n a r y ( 2 5 5 ) ; m o n e y ; i n t ; s m a l l i n t ; f l o a t ; r e a l ; f l o a t ; v a r c h a r ; d a t e t i m e ; d a t e t i m e ; d a t e t i m e ; t e x t ; v a r b i n a r y ; i m a g e ; t i n y i n t ; b i t ; g s e l e c t n a m e f r o m m a s t e r . . s y s d a t a b a s e s w h e r e n a m e l i k e ' % s ' a n d n a m e < > ' m o d e l ' a n d h a s _ d b a c c e s s ( n a m e ) = 1 B u l g a r i a n ; C r o a t i a n ; C z e c h ; D a n i s h ; D u t c h ; F i n n i s h ; f r a n a i s ; d e u t s c h ; G r e e k ; H u n g a r i a n ; I t a l i a n ; J a p a n e s e ; N o r w e g i a n ; P o l i s h ; P o r t u g e s e ; R o m a n i a n ; R u s s i a n ; S l o v a k ; S l o v e n e ; S p a n i s h ; S w e d i s h ; u s _ e n g l i s h ; B u l g a r i a n ; C r o a t i a n ; C z e c h ; D a n i s h ; D u t c h ; F i n n i s h ; F r e n c h ; G e r m a n ; G r e e k ; H u n g a r i a n ; I t a l i a n ; J a p a n e s e ; N o r w e g i a n ; P o l i s h ; P o r t u g e s e ; R o m a n i a n ; R u s s i a n ; S l o v a k ; S l o v e n e ; S p a n i s h ; S w e d i s h ; E n g l i s h ;
w h e r e 1 = 2  0 3 . 5 2 # ' % 0 4 d % 0 2 u % 0 2 u % 0 2 u : % 0 2 u : % 0 2 u . % 0 3 l u ' P s e l e c t ' E n g l i s h ' , ' u s _ e n g l i s h ' u n i o n s e l e c t a l i a s , n a m e f r o m m a s t e r . . s y s l a n g u a g e s % s e l e c t n a m e f r o m m a s t e r . . s y s d a t a b a s e s
s e t l a n g u a g e @ s e l e c t n a m e f r o m m a s t e r . . s y s d a t a b a s e s w h e r e h a s _ d b a c c e s s ( n a m e ) = 1 S Q L S R V 3 2 . D L L  s p _ s e r v e r _ i n f o 1 W s e l e c t s u b s t r i n g ( ' N Y ' , s t a t u s / 1 0 2 4 & 1 + 1 , 1 ) f r o m m a s t e r . . s y s d a t a b a s e s w h e r e n a m e = D B _ N A M E ( )  1 9 9 5  s e l e c t @ @ l a n g u a g e  s e l e c t d b _ n a m e ( ) N s e l e c t n a m e f r o m m a s t e r . . s y s d a t a b a s e s w h e r e n a m e l i k e ' % s ' a n d n a m e < > ' m o d e l ' u s e l e c t T A B L E _ Q U A L I F I E R = c o n v e r t ( s y s n a m e , ' % s ' ) , T A B L E _ O W N E R = c o n v e r t ( s y s n a m e , u 1 . n a m e ) , T A B L E _ N A M E = c o n v e r t ( s y s n a m e , o . n a m e ) , T A B L E _ T Y P E = c o n v e r t ( v a r c h a r ( 3 2 ) , r t r i m ( s u b s t r i n g ( ' S Y S T E M T A B L E T A B L E V I E W ' , ( a s c i i ( o . t y p e ) - 8 3 ) * 1 2 + 1 , 1 2 ) ) ) , R E M A R K S = c o n v e r t ( v a r c h a r ( 2 5 4 ) , n u l l ) f r o m % s . . s y s u s e r s u , % s . . s y s u s e r s u 1 , % s . . s y s o b j e c t s o w h e r e o . n a m e l i k e ' % s ' a n d u 1 . n a m e l i k e ' % s ' a n d c h a r i n d e x ( s u b s t r i n g ( o . t y p e , 1 , 1 ) , ' % s ' ) ! = 0 a n d u 1 . u i d = o . u i d a n d ( u . s u i d = s u s e r _ i d ( ) o r ( s u s e r _ i d ( ) = 1 a n d u . u i d = 1 ) ) a n d ( s u s e r _ i d ( ) = 1 o r o . u i d = u . u i d o r ( ( s e l e c t m a x ( ( ( s i g n ( u i d ) * a b s ( u i d - 1 6 3 8 3 ) ) * 2 ) + ( p r o t e c t t y p e & 1 ) ) f r o m % s . . s y s p r o t e c t s p w h e r e p . i d = * o . i d a n d ( p . u i d = 0 o r p . u i d = * u . u i d o r p . u i d = * u . g i d ) a n d ( a c t i o n i n ( 1 9 3 , 2 2 4 ) ) ) & 1 ) = 1 ) u n i o n  o r d e r b y 4 , 1 , 2 , 3  ' S Y S T E M T A B L E '  ' T A B L E '  ' V I E W ' 4 s e l e c t ' % s ' f r o m % s . . s y s u s e r s w h e r e s u i d = s u s e r _ i d ( ) s e l e c t c . n a m e f r o m m a s t e r . d b o . s y s c h a r s e t s c , m a s t e r . d b o . s y s c h a r s e t s c 1 , m a s t e r . d b o . s y s c o n f i g u r e s f w h e r e f . c o n f i g i n ( 1 2 3 , 1 1 2 3 ) a n d f . v a l u e = c 1 . i d a n d c 1 . c s i d = c . i d , s e l e c t a l i a s , n a m e f r o m m a s t e r . . s y s l a n g u a g e s 0 S E T T R A N S A C T I O N I S O L A T I O N L E V E L R E A D U N C O M M I T T E D . S E T T R A N S A C T I O N I S O L A T I O N L E V E L R E A D C O M M I T T E D B R E A K , B R O W S E , B U L K , C H E C K P O I N T , C L U S T E R E D , C O M M I T T E D , C O M P U T E , C O N F I R M , C O N T R O L R O W , D A T A B A S E , D B C C , D I S K , D I S T R I B U T E D , D U M M Y , D U M P , E R R L V L , E R R O R E X I T , E X I T , F I L E , F I L L F A C T O R , F L O P P Y , H O L D L O C K , I D E N T I T Y _ I N S E R T , I D E N T I T Y C O L , I F , K I L L , L I N E N O , L O A D , M I R R O R E X I T , N O N C L U S T E R E D , O F F , O F F S E T S , O N C E , O V E R , P E R C E N T , P E R M , P E R M A N E N T , P L A N , P R I N T , P R O C , P R O C E S S E X I T , R A I S E R R O R , R E A D , R E A D T E X T , R E C O N F I G U R E , R E P E A T A B L E , R E T U R N , R O W C O U N T , R U L E , S A V E , S E R I A L I Z A B L E , S E T U S E R , S H U T D O W N , S T A T I S T I C S , g T A P E , T E M P , T E X T S I Z E , T O P , T R A N , T R I G G E R , T R U N C A T E , T S E Q U E L , U N C O M M I T T E D , U P D A T E T E X T , U S E , W A I T F O R , W H I L E , W R I T E T E X T  n c h a r  b i t  t i n y i n t  b i g i n t  i m a g e v a r b i n a r y  b i n a r y  t e x t  c h a r  n u m e r i c  d e c i m a l  i n t  s m a l l i n t  f l o a t  r e a l  S Q L B I T  S Q L I N T  S Q L C H A R  S Q L F L T 8  S Q L F L T 4  S Q L M O N E Y S Q L B I N A R Y S Q L M O N E Y 4
S Q L T I N Y I N T S Q L S M A L L I N T S Q L V A R Y C H A R
S Q L V A R Y B I N S Q L D A T E T I M E S Q L D A T E T I M 4
S Q L N U M E R I C
S Q L D E C I M A L  S Q L N C H A R S Q L N V A R C H A R S Q L U N I Q U E I D
S Q L V A R I A N T S Q L B I G I N T  S Q L I M A G E  a v g  c n t  m a x  m i n  s u m  s t d e v  s t d e v p  v a r  v a r p
D R O P I N D E X C R E A T E I N D E X A L T E R T A B L E  C A L L C R E A T E T A B L E  D Y N A M I C U P D A T E C U R S O R U P D A T E W H E R E C R E A T E V I E W
S E L E C T C U R S O R D E L E T E W H E R E D R O P S C H E M A
D R O P T A B L E D R O P V I E W  D Y N A M I C D E L E T E C U R S O R  G R A N T  I N S E R T  R E V O K E  A L T E R D A T A B A S E D R O P D E F A U L T
D R O P D A T A B A S E  D I S K  D B C C  D E A L L O C A T E C U R S O R
D Y N A M I C C L O S E
D Y N A M I C F E T C H D Y N A M I C O P E N  D E C L A R E C U R S O R  C R E A T E T R I G G E R C R E A T E R U L E  C R E A T E P R O C E D U R E  C R E A T E D E F A U L T  C R E A T E D A T A B A S E C O N D I T I O N
C H E C K P O I N T  S E T T R A N S A C T I O N I S O L A T I O N L E V E L  D E N Y W R I T E T E X T  W A I T F O R  U S E
U P D A T E T E X T  U P D A T E S T A T I S T I C S  R E A D T E X T R A I S E R R O R  P R I N T  L O A D T R A N S A C T I O N
L O A D T A B L E  L O A D H E A D E R O N L Y
L O A D D A T A B A S E  K I L L I N S E R T B U L K  G O T O  D U M P T R A N S A C T I O N
D U M P T A B L E
D U M P D A T A B A S E D R O P T R I G G E R D R O P R U L E  D R O P P R O C E D U R E  T R U N C A T E T A B L E  S A V E T R A N S A C T I O N
R O L L B A C K W O R K  P R E P A R E T R A N S A C T I O N C O M M I T W O R K  B E G I N T R A N S A C T I O N  S H U T D O W N  S E T U S E R S E T T E X T S I Z E  S E T S T A T I S T I C S S E T R O W C O U N T  S E T I D E N T I T Y _ I N S E R T  S E T S E L E C T I N T O  R E T U R N R E C O N F I G U R E
2 1 S 0 1 2 1 S 0 1
2 1 S 0 1 2 1 S 0 1
0 7 0 0 8 0 7 0 0 8
0 7 0 0 8 0 7 0 0 8
2 2 0 0 3 2 2 0 0 3
2 2 0 0 5 2 2 0 1 8
S 0 0 2 2 4 2 S 2 2
S 0 0 0 2 4 2 S 0 2
2 2 0 0 8 2 2 0 0 7
2 2 0 0 8 2 2 0 0 7
2 1 S 0 1 2 1 S 0 1
2 2 0 0 3 2 2 0 0 3
2 3 0 0 0 2 3 0 0 0
4 2 0 0 0 4 2 0 0 0
4 2 0 0 0 4 2 0 0 0
2 2 0 0 3 2 2 0 0 3
2 3 0 0 0 2 3 0 0 0
2 2 0 0 3 2 2 0 0 3
2 2 0 0 5 2 2 0 1 8
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
S 0 0 0 2 4 2 S 0 2
2 2 0 0 3 2 2 0 0 3
2 2 0 0 8 2 2 0 0 7
2 2 0 0 8 2 2 0 0 7
2 2 0 0 3 2 2 0 0 3
2 2 0 0 5 2 2 0 1 8
2 2 0 0 3 2 2 0 0 3
2 2 0 0 5 2 2 0 1 8
2 2 0 0 3 2 2 0 0 3
2 2 0 0 5 2 2 0 1 8
2 2 0 0 5 2 2 0 1 8
2 5 0 0 0 2 5 0 0 0
S 0 0 0 2 4 2 S 0 2
2 3 0 0 0 2 3 0 0 0
2 3 0 0 0 2 3 0 0 0
2 5 0 0 0 2 5 0 0 0
2 2 0 0 8 2 2 0 0 7
2 2 0 0 8 2 2 0 0 7
2 2 0 0 5 2 2 0 1 8
2 2 0 2 5 2 2 0 2 5
2 2 0 0 5 2 2 0 1 8
2 1 0 0 0 2 1 0 0 0
2 3 0 0 0 2 3 0 0 0
2 2 0 0 8 2 2 0 0 7
2 2 0 0 5 2 2 0 1 8
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
2 2 0 0 3 2 2 0 0 3
2 2 0 0 5 2 2 0 1 8
2 3 0 0 0 2 3 0 0 0
2 2 0 0 3 2 2 0 0 3
2 3 0 0 0 2 3 0 0 0
2 3 0 0 0 2 3 0 0 0
4 4 0 0 0 4 4 0 0 0
2 5 0 0 0 2 5 0 0 0
2 5 0 0 0 2 5 0 0 0
0 8 0 0 4 0 8 0 0 4
0 8 0 0 4 0 8 0 0 4
0 1 0 0 0 0 1 0 0 0
0 1 0 0 0 0 1 0 0 0
2 2 0 0 3 2 2 0 0 3
2 2 0 1 9 2 2 0 1 9
4 0 0 0 1 4 0 0 0 1
4 0 0 0 1 4 0 0 0 1
2 3 0 0 0 2 3 0 0 0
2 3 0 0 0 2 3 0 0 0
S 0 0 0 2 4 2 S 0 2
S 0 0 2 2 4 2 S 2 2
S 0 0 1 1 4 2 S 1 1
S 0 0 0 2 4 2 S 0 2
2 3 0 0 0 2 3 0 0 0
2 3 0 0 0 2 3 0 0 0
4 0 0 0 1 4 0 0 0 1
2 3 0 0 0 2 3 0 0 0
2 3 0 0 0 2 3 0 0 0
S 0 0 2 1 4 2 S 2 1
S 0 0 0 2 4 2 S 0 2
S 0 0 0 1 4 2 S 0 1
S 0 0 2 1 4 2 S 2 1
S 0 0 0 2 4 2 S 0 2
0 8 0 0 4 0 8 0 0 4
S 0 0 1 2 4 2 S 1 2
4 0 0 0 1 4 0 0 0 1
2 3 0 0 0 2 3 0 0 0
2 3 0 0 0 2 3 0 0 0
0 1 0 0 0 0 1 0 0 0
0 1 0 0 0 0 1 0 0 0
0 1 0 0 0 0 1 0 0 0
S 0 0 0 2 4 2 S 0 2
S 0 0 1 2 4 2 S 1 2
S 0 0 1 2 4 2 S 1 2
2 5 0 0 0 2 5 0 0 0
2 5 0 0 0 2 5 0 0 0
2 5 0 0 0 2 5 0 0 0
2 5 0 0 0 2 5 0 0 0
2 8 0 0 0 2 8 0 0 0
0 8 0 0 4 0 8 0 0 4
0 8 0 0 4 0 8 0 0 4
S 0 0 1 2 4 2 S 1 2
S 0 0 0 2 4 2 S 0 2
S 0 0 0 2 4 2 S 0 2
2 1 S 0 2 2 1 S 0 2
2 1 S 0 2 2 1 S 0 2
2 1 S 0 2 2 1 S 0 2
S 0 0 2 1 4 2 S 2 1
S 0 0 2 1 4 2 S 2 1
S 0 0 0 2 4 2 S 0 2
S 0 0 0 2 4 2 S 0 2
S 0 0 2 2 4 2 S 2 2
0 1 0 0 0 0 1 0 0 0
0 1 0 0 0 0 1 0 0 0
S 0 0 1 2 4 2 S 1 2
2 5 0 0 0 2 5 0 0 0
4 0 0 0 1 4 0 0 0 1
2 3 0 0 0 2 3 0 0 0
2 2 0 0 3 2 2 0 0 3
2 2 0 1 2 2 2 0 1 2
2 2 0 0 1 2 2 0 0 1
0 1 0 0 3 0 1 0 0 3
S 1 1 0 9 H Y 1 0 9
3 4 0 0 0 3 4 0 0 0
2 4 0 0 0 2 4 0 0 0
2 4 0 0 0 2 4 0 0 0
0 1 S 0 3 0 1 0 0 1
0 1 S 0 3 0 1 0 0 1
0 8 0 0 4 0 8 0 0 4
0 8 0 0 4 0 8 0 0 4
2 8 0 0 0 2 8 0 0 0
2 8 0 0 0 2 8 0 0 0
0 8 0 0 4 0 8 0 0 4
2 8 0 0 0 2 8 0 0 0 0 0 1 0 0 0 0 1 0 0 0 O n g o i n g t r a n s a c t i o n h a s b e e n c o m m i t t e d 0 1 0 0 0 0 1 0 0 0 T h e O D B C c a t a l o g s t o r e d p r o c e d u r e s i n s t a l l e d o n s e r v e r % s a r e v e r s i o n % s ; v e r s i o n % 0 2 d . % 0 2 d . % 4 . 4 d o r l a t e r i s r e q u i r e d t o e n s u r e p r o p e r o p e r a t i o n . P l e a s e c o n t a c t y o u r s y s t e m a d m i n i s t r a t o r . Q 0 1 0 0 0 0 1 0 0 0 A c c e s s t o d a t a b a s e c o n f i g u r e d i n t h e D S N h a s b e e n d e n i e d . D e f a u l t u s e d . H 0 1 0 0 0 0 1 0 0 0 L a n g u a g e c o n f i g u r e d i n t h e D S N i s n o t s u p p o r t e d . D e f a u l t u s e d . I 0 1 0 0 0 0 1 0 0 0 P r o c e d u r e e x e c u t e d w i t h ' E X E C ' . N o o u t p u t p a r a m e t e r s r e t u r n e d . [ 0 1 0 0 0 0 1 0 0 0 A n e r r o r h a s o c c u r r e d d u r i n g a n a t t e m p t t o a c c e s s t h e l o g f i l e , l o g g i n g d i s a b l e d . $ 0 1 0 0 0 0 1 0 0 0 C o n n e c t e d t o b a c k u p s e r v e r 0 1 0 0 0 0 1 0 0 0 S Q L D e b u g g i n g d i s a b l e d ' 0 1 0 0 4 0 1 0 0 4 S t r i n g d a t a , r i g h t t r u n c a t i o n 6 0 1 0 0 0 0 1 0 0 0 % l d r o w s s e n t t o S Q L S e r v e r . T o t a l s e n t : % l d ' 0 1 0 0 4 0 1 0 0 4 S t r i n g d a t a , r i g h t t r u n c a t i o n M 0 1 0 0 0 0 1 0 0 0 % l d r o w s s u c c e s s f u l l y b u l k - c o p i e d t o h o s t - f i l e . T o t a l r e c e i v e d : % l d - 0 1 0 0 0 0 1 0 0 0 Z e r o l e n g t h d a t a f o r c e d t o l e n g t h 1 & 0 1 0 0 0 0 1 0 0 0 N u l l b i t d a t a f o r c e d t o z e r o  0 1 0 0 0 0 1 0 0 0 C u r s o r w a s n o t c l o s e d < 0 1 0 0 0 0 1 0 0 0 W a r n i n g : C o d e p a g e t r a n s l a t i o n c a u s e d l o s s o f d a t a - 0 1 S 0 0 0 1 S 0 0 I n v a l i d c o n n e c t i o n s t r i n g a t t r i b u t e  0 1 S 0 1 0 1 S 0 1 E r r o r i n r o w  0 1 S 0 2 0 1 S 0 2 O p t i o n v a l u e c h a n g e d D 0 1 S 0 2 0 1 S 0 2 P a c k e t s i z e c h a n g e n o t h o n o r e d b y s e r v e r , s e r v e r s i z e u s e d  0 1 S 0 2 0 1 S 0 2 P a c k e t s i z e c h a n g e d  0 1 S 0 2 0 1 S 0 2 C u r s o r t y p e c h a n g e d $ 0 1 S 0 2 0 1 S 0 2 C u r s o r c o n c u r r e n c y c h a n g e d  0 1 S 0 2 0 1 S 0 2 L o g i n t i m e o u t c h a n g e d # 0 1 S 0 3 0 1 0 0 1 C u r s o r o p e r a t i o n c o n f l i c t * 0 1 S 0 5 0 1 S 0 5 C a n c e l t r e a t e d a s F r e e S t m t / C l o s e F 0 1 S 0 6 0 1 S 0 6 A t t e m p t t o f e t c h b e f o r e t h e r e s u l t r e t u r n e d t h e f i r s t r o w s e t  0 1 0 0 4 0 1 S 0 7 F r a c t i o n a l t r u n c a t i o n ] 0 7 0 0 1 0 7 0 0 2 U n a b l e t o d e r i v e p a r a m e t e r i n f o r m a t i o n w h e n p a r a m e t e r m a r k e r i s a f u n c t i o n a r g u m e n t / 0 7 0 0 1 0 7 0 0 2 C O U N T f i e l d i n c o r r e c t o r s y n t a x e r r o r 2 0 7 0 0 6 0 7 0 0 6 R e s t r i c t e d d a t a t y p e a t t r i b u t e v i o l a t i o n * 0 7 S 0 1 0 7 S 0 1 I n v a l i d u s e o f d e f a u l t p a r a m e t e r / 0 8 0 0 1 0 8 0 0 1 C l i e n t u n a b l e t o e s t a b l i s h c o n n e c t i o n ( 0 8 0 0 4 0 8 0 0 4 S e r v e r r e j e c t e d t h e c o n n e c t i o n $ 0 8 S 0 1 0 8 S 0 1 C o m m u n i c a t i o n l i n k f a i l u r e 6 2 1 S 0 1 2 1 S 0 1 I n s e r t v a l u e l i s t d o e s n o t m a t c h c o l u m n l i s t < 2 1 S 0 2 2 1 S 0 2 D e g r e e o f d e r i v e d t a b l e d o e s n o t m a t c h c o l u m n l i s t ' 2 2 0 0 1 2 2 0 0 1 S t r i n g d a t a , r i g h t t r u n c a t i o n 6 2 2 0 0 2 2 2 0 0 2 I n d i c a t o r v a r i a b l e r e q u i r e d b u t n o t s u p p l i e d $ 2 2 0 0 3 2 2 0 0 3 N u m e r i c v a l u e o u t o f r a n g e 8 2 2 0 0 5 2 2 0 1 8 I n v a l i d c h a r a c t e r v a l u e f o r c a s t s p e c i f i c a t i o n  2 2 0 0 8 2 2 0 0 7 I n v a l i d d a t e f o r m a t  2 2 0 0 8 2 2 0 0 7 I n v a l i d t i m e f o r m a t ! S 1 1 0 9 H Y 1 0 9 I n v a l i d c u r s o r p o s i t i o n S 1 1 1 1 H Y 1 1 1 I n v a l i d b o o k m a r k v a l u e * S 1 C 0 0 H Y C 0 0 O p t i o n a l f e a t u r e n o t i m p l e m e n t e d  S 1 T 0 0 H Y T 0 0 T i m e o u t e x p i r e d # 0 8 0 0 3 0 8 0 0 3 C o n n e c t i o n d o e s n o t e x i s t : 2 2 0 0 3 H Y 0 1 9 N o n - c h a r a c t e r a n d n o n - b i n a r y d a t a s e n t i n p i e c e s : 2 4 0 0 0 0 7 0 0 5 P r e p a r e d s t a t e m e n t i s n o t a c u r s o r - s p e c i f i c a t i o n D S 1 0 0 0 H Y 0 0 0 A t t e m p t t o b u l k - c o p y a n o v e r s i z e d c o l u m n t o t h e S Q L S e r v e r C S 1 0 0 0 H Y 0 0 0 T h e B C P h o s t - f i l e c o n t a i n s l e s s r o w s t h a n f i r s t r o w c o u n t 1 0 8 0 0 1 0 8 0 0 1 N e i t h e r D S N n o r S E R V E R k e y w o r d s u p p l i e d ) S 1 0 0 0 H Y 0 0 0 A l l b o u n d c o l u m n s a r e r e a d - o n l y ( S 1 0 0 0 H Y 0 0 0 C a n n o t i n i t i a l i z e S S P I p a c k a g e & S 1 0 0 0 H Y 0 0 0 C a n n o t g e n e r a t e S S P I c o n t e x t % S 1 0 0 0 H Y 0 0 0 T e x t c o l u m n d a t a i n c o m p l e t e ! 2 2 0 0 8 2 2 0 0 8 D a t e t i m e f i e l d o v e r f l o w 4 0 7 0 0 6 0 7 0 0 6 C o n v e r s i o n s n o t a l l o w e d u s i n g b c p _ m o r e t e x t D S 1 0 0 0 H Y 0 0 0 T h e r o w l e n g t h e x c e e d s S Q L S e r v e r ' s m a x i m u m a l l o w a b l e s i z e m S 1 0 0 0 H Y 0 0 0 U n i c o d e c o n v e r s i o n f a i l e d . T h e c o d e p a g e o f t h e S Q L s e r v e r m u s t b e i n s t a l l e d o n t h e c l i e n t s y s t e m . / S 1 0 0 0 H Y 0 0 0 I / O e r r o r w h i l e r e a d i n g B C P d a t a - f i l e " S 1 0 0 0 H Y 0 0 0 N o t e n o u g h c o l u m n s b o u n d ^ S 1 0 0 0 H Y 0 0 0 A n o l d n e t l i b ( % s ) h a s b e e n d e t e c t e d . P l e a s e d e l e t e i t a n d r e s t a r t t h e a p p l i c a t i o n . 3 S 1 0 0 9 H Y 0 2 4 D a t a b a s e i s i n v a l i d o r c a n n o t b e a c c e s s e d ' S 1 0 0 0 H Y 0 0 0 U n a b l e t o r e a d d r i v e r v e r s i o n " 2 2 0 0 8 2 2 0 0 7 I n v a l i d t i m e s t a m p f o r m a t & 2 2 0 2 6 2 2 0 2 6 S t r i n g d a t a , l e n g t h m i s m a t c h  2 4 0 0 0 2 4 0 0 0 I n v a l i d c u r s o r s t a t e # 2 5 0 0 0 2 5 0 0 0 I n v a l i d t r a n s a c t i o n s t a t e - 2 8 0 0 0 2 8 0 0 0 I n v a l i d a u t h o r i z a t i o n s p e c i f i c a t i o n U 0 8 0 0 4 0 8 0 0 4 S e r v e r r e j e c t e d t h e c o n n e c t i o n ; A c c e s s t o s e l e c t e d d a t a b a s e h a s b e e n d e n i e d M 0 8 0 0 4 0 8 0 0 4 S e r v e r r e j e c t e d t h e c o n n e c t i o n ; L a n g u a g e s p e c i f i e d i s n o t s u p p o r t e d  3 4 0 0 0 3 4 0 0 0 I n v a l i d c u r s o r n a m e * 3 7 0 0 0 4 2 0 0 0 S y n t a x e r r o r o r a c c e s s v i o l a t i o n  3 C 0 0 0 3 C 0 0 0 D u p l i c a t e c u r s o r n a m e ( 7 0 1 0 0 H Y 0 1 8 S e r v e r d e c l i n e d c a n c e l r e q u e s t B I M 0 0 6 I M 0 0 6 P a c k e t s i z e c h a n g e n o t s u p p o r t e d b y s e r v e r , d e f a u l t u s e d  I M 0 0 8 I M 0 0 8 D i a l o g f a i l e d ; S 1 0 1 1 H Y 0 2 0 A t t e m p t t o c o n c a t e n a t e t o a n u l l o r d e f a u l t v a l u e 8 S 1 0 1 6 H Y 0 1 6 C a n n o t m o d i f y a n i m p l e m e n t a t i o n r o w d e s c r i p t o r  S 1 0 0 4 H Y 0 0 4 I n v a l i d S Q L d a t a t y p e ! 2 2 0 1 5 2 2 0 1 5 I n t e r v a l f i e l d o v e r f l o w . S 1 0 0 7 H Y 0 0 7 A s s o c i a t e d s t a t e m e n t i s n o t p r e p a r e d ! S 1 0 0 9 H Y 0 2 4 I n v a l i d a t t r i b u t e v a l u e + S 1 0 0 0 H Y 0 0 0 C o n n e c t i o n i s n o t e n a b l e d f o r B C P ) S 1 0 0 0 H Y 0 0 0 O D B C B C P / D r i v e r v e r s i o n m i s m a t c h # S 1 0 0 0 H Y 0 0 0 U n i c o d e c o n v e r s i o n f a i l e d 6 S 1 0 0 0 H Y 0 0 0 B a d B C P d i r e c t i o n . M u s t b e e i t h e r I N o r O U T + S 1 0 0 0 H Y 0 0 0 U n a b l e t o o p e n B C P h o s t d a t a - f i l e ? 2 5 S 1 1 2 5 S 1 1 E n l i s t m e n t i s n o t p o s s i b l e d u e t o p e n d i n g t r a n s a c t i o n ' 2 5 S 1 2 2 5 S 1 2 D i s t r i b u t e d t r a n s a c t i o n e r r o r  S 1 0 0 8 H Y 0 0 8 O p e r a t i o n c a n c e l e d % S 1 0 0 9 H Y 0 0 9 I n v a l i d u s e o f n u l l p o i n t e r ! S 1 0 1 0 H Y 0 1 0 F u n c t i o n s e q u e n c e e r r o r ( S 1 0 1 1 H Y 0 1 1 O p e r a t i o n i n v a l i d a t t h i s t i m e " S 1 0 1 5 H Y 0 1 5 N o c u r s o r n a m e a v a i l a b l e ) S 1 0 9 0 H Y 0 9 0 I n v a l i d s t r i n g o r b u f f e r l e n g t h - S 1 0 9 1 H Y 0 9 1 I n v a l i d d e s c r i p t o r f i e l d i d e n t i f i e r - S 1 0 9 2 H Y 0 9 2 I n v a l i d a t t r i b u t e / o p t i o n i d e n t i f i e r " S 1 0 9 3 0 7 0 0 9 I n v a l i d p a r a m e t e r n u m b e r - S 1 0 2 1 H Y 0 2 1 I n c o n s i s t e n t d e s c r i p t o r i n f o r m a t i o n  S 1 0 9 4 H Y 1 0 4 I n v a l i d s c a l e v a l u e " S 1 0 9 6 H Y 0 9 6 I n v a l i d i n f o r m a t i o n t y p e ! S 1 1 0 4 H Y 1 0 4 I n v a l i d p r e c i s i o n v a l u e S 1 1 0 5 H Y 1 0 5 I n v a l i d p a r a m e t e r t y p e ! S 1 1 0 6 H Y 1 0 6 F e t c h t y p e o u t o f r a n g e S 1 1 0 7 H Y 1 0 7 R o w v a l u e o u t o f r a n g e S 1 0 0 0 H Y 0 0 0 T h e s t o r e d p r o c e d u r e r e q u i r e d t o c o m p l e t e t h i s o p e r a t i o n c o u l d n o t b e f o u n d o n t h e s e r v e r ( t h e y w e r e s u p p l i e d w i t h S Q L S e r v e r ) . P l e a s e c o n t a c t y o u r s y s t e m a d m i n i s t r a t o r . 0 S 1 0 0 0 H Y 0 0 0 U n k n o w n t o k e n r e c e i v e d f r o m S Q L S e r v e r X S 1 0 0 0 H Y 0 0 0 U n a b l e t o l o a d c o m m u n i c a t i o n m o d u l e . D r i v e r h a s n o t b e e n c o r r e c t l y i n s t a l l e d . V S 1 0 0 0 H Y 0 0 0 C o m m u n i c a t i o n m o d u l e i s n o t v a l i d . D r i v e r h a s n o t b e e n c o r r e c t l y i n s t a l l e d . i S 1 0 0 0 H Y 0 0 0 W a r n i n g : P a r t i a l i n s e r t / u p d a t e . T h e i n s e r t / u p d a t e o f a t e x t o r i m a g e c o l u m n ( s ) d i d n o t s u c c e e d . ; S 1 0 0 0 H Y 0 0 0 C o n n e c t i o n i s b u s y w i t h r e s u l t s f o r a n o t h e r h s t m t . S 1 0 0 0 H Y 0 0 0 F a i l u r e d u r i n g c l o s i n g o f c o n n e c t i o n & S 1 0 0 0 H Y 0 0 0 P r o t o c o l e r r o r i n T D S s t r e a m % S 1 0 0 0 H Y 0 0 0 T D S b u f f e r l e n g t h t o o l a r g e C S 1 0 0 0 H Y 0 0 0 N o n - d e f a u l t p a r a m e t e r n o t a l l o w e d a f t e r d e f a u l t p a r a m e t e r # S 1 0 0 1 H Y 0 0 1 M e m o r y a l l o c a t i o n f a i l u r e " S 1 0 0 2 0 7 0 0 9 I n v a l i d D e s c r i p t o r I n d e x ) S 1 0 0 3 H Y 0 0 3 I n v a l i d a p p l i c a t i o n b u f f e r t y p e ' S 1 0 0 0 H Y 0 0 0 U n a b l e t o o p e n B C P e r r o r - f i l e ) S 1 0 0 0 H Y 0 0 0 T a b l e h a s n o t e x t / i m a g e c o l u m n s 0 S 1 0 0 0 H Y 0 0 0 I / O e r r o r w h i l e w r i t i n g B C P e r r o r - f i l e  S 1 0 0 0 H Y 0 0 0 I n v a l i d o p t i o n b S 1 0 0 0 H Y 0 0 0 A t t e m p t t o b u l k - c o p y a N U L L v a l u e i n t o a S e r v e r c o l u m n w h i c h d o e s n o t a c c e p t N U L L v a l u e s 9 S 1 0 0 0 H Y 0 0 0 B C P h o s t - f i l e s m u s t c o n t a i n a t l e a s t o n e c o l u m n / S 1 0 0 0 H Y 0 0 0 I / O e r r o r w h i l e w r i t i n g B C P d a t a - f i l e L S 1 0 0 0 H Y 0 0 0 H o s t - f i l e c o l u m n s m a y b e s k i p p e d o n l y w h e n c o p y i n g i n t o t h e S e r v e r 5 S 1 0 0 0 H Y 0 0 0 U n e x p e c t e d E O F e n c o u n t e r e d i n B C P d a t a - f i l e < S 1 0 0 0 H Y 0 0 0 A t t e m p t t o r e a d u n k n o w n v e r s i o n o f B C P f o r m a t f i l e ? S 1 0 0 0 H Y 0 0 0 I n c o r r e c t h o s t - c o l u m n n u m b e r f o u n d i n B C P f o r m a t - f i l e  S 1 0 0 0 H Y 0 0 0 B a d t e r m i n a t o r f S 1 0 0 0 H Y 0 0 0 F o r B C P , a l l v a r i a b l e - l e n g t h d a t a m u s t h a v e e i t h e r a l e n g t h - p r e f i x o r a t e r m i n a t o r s p e c i f i e d 1 S 1 0 0 0 H Y 0 0 0 I / O e r r o r w h i l e r e a d i n g B C P f o r m a t f i l e 7 S 1 0 0 0 H Y 0 0 0 T a b l e c o n t a i n s l e s s r o w s t h a n f i r s t r o w c o u n t 6 S 1 0 0 0 H Y 0 0 0 T a b l e c o n t a i n s l e s s r o w s t h a n l a s t r o w c o u n t : S 1 1 1 2 H Y 1 1 2 C o n v e r s i o n t o s q l _ v a r i a n t s u b t y p e n o t s u p p o r t e d % S 1 0 0 0 H Y 0 0 0 I n v a l i d f o r m a t f i l e v e r s i o n 3 S 1 0 0 0 H Y 0 0 0 U n a b l e t o r e s o l v e c o l u m n l e v e l c o l l a t i o n s 3 S 1 0 0 0 H Y 0 0 0 I n c o r r e c t f o r m a t f o r n a t i v e v a r i a n t f i e l d F S 1 1 1 2 H Y 1 1 3 V a r i a n t o p e r a t i o n r e q e s t e d o n c o l u m n t h a t i s n o t s q l _ v a r i a n t 5 S 1 0 0 0 H Y 0 0 0 I n v a l i d b u f f e r s i z e f o r B C P c o l u m n p r o p e r t y % S 1 0 0 0 H Y 0 0 0 U n k n o w n B C P c o l u m n p r o p e r t y I S 1 0 0 0 H Y 0 0 0 T e x t f i l e m o d e s e l e c t e d . C h a r a c t e r c o l u m n t y p e s o n l y e x p e c t e d . W S 1 0 0 0 H Y 0 0 0 F i e l d s i z e u n d e f i n e d . C o l u m n t y p e c a n n o t b e s e t u n t i l f i e l d s i z e i s d e f i n e d . d S 1 0 0 0 H Y 0 0 0 S e r v e r c o l u m n u n d e f i n e d . C o l u m n t y p e c a n n o t b e s e t u n t i l s e r v e r c o l u m n n u m b e r i s d e f i n e d . ) S 1 0 0 0 H Y 0 0 0 I n v a l i d f i e l d s i z e f o r d a t a t y p e T S 1 0 0 0 H Y 0 0 0 C o l l a t i o n n a m e [ % s ] c o u l d n o t b e r e s o l v e d f o r c o l u m n [ % s ] b y t a r g e t s e r v e r R S 1 0 0 0 H Y 0 0 0 S e r v e r c o l u m n o r d e r m u s t m a t c h f i e l d o r d e r o f f i l e f o r B C P w i t h Q U E R Y O U T  S 1 0 0 0 H Y 0 0 0 C o l u m n n u m b e r i n v a l i d  S 1 0 0 0 H Y 0 0 0 I n v a l i d b u f f e r 5 S 1 0 0 0 H Y 0 0 0 C o d e p a g e % d i s n o t s u p p o r t e d b y S Q L S e r v e r f S 1 0 0 0 H Y 0 0 0 U n s p e c i f i e d e r r o r o c c u r r e d o n S Q L S e r v e r . C o n n e c t i o n m a y h a v e b e e n t e r m i n a t e d b y t h e s e r v e r . S 1 0 0 0 H Y 0 0 0 W a r n i n g : S e r v e r d a t a ( % d b y t e s ) e x c e e d s h o s t - f i l e f i e l d l e n g t h ( % d b y t e s ) f o r f i e l d ( % d ) . U s e p r e f i x l e n g t h , t e r m i n a t i o n s t r i n g , o r a l a r g e r h o s t - f i l e f i e l d s i z e . T r u n c a t i o n c a n n o t o c c u r f o r B C P o u t p u t f i l e s .  C a n n o t d r o p t h e i n d e x  M i c r o s o f t S Q L S e r v e r L o g i n  t a b l e  o w n e r  d a t a b a s e  s t o r e d p r o c e d u r e  ( l o c a l ) & M i c r o s o f t S Q L S e r v e r D S N C o n f i g u r a t i o n ( % s c a n n o t b e u s e d a s a d a t a s o u r c e n a m e .  H e l p i s n o t a v a i l a b l e , % s i s a l r e a d y a d a t a s o u r c e n a m e .
O v e r w r i t e ? & I n v a l i d c h a r a c t e r i n d a t a s o u r c e n a m e . ' % s i s n o t a n e x i s t i n g d a t a s o u r c e n a m e . = D o y o u w a n t t o c o n v e r t y o u r S Q L S e r v e r 1 6 b i t D S N s t o 3 2 b i t ? 6 F i l l i n g l i s t b o x r e q u i r e s a v a l i d L o g i n I d a n d P a s s w o r d @ F i l l i n g l i s t b o x f a i l e d :
S Q L S t a t e : ' % s '
S Q L S e r v e r E r r o r : % l d
% s ; C o n n e c t i o n f a i l e d :
S Q L S t a t e : ' % s '
S Q L S e r v e r E r r o r : % l d
% s
 & S e r v e r : ( D e f a u l t )  S e l e c t L o g F i l e * L o g F i l e s ( * . l o g ) | * . l o g | A l l F i l e s ( * . * ) | * . * | - Q u e r y L o g g i n g T h r e s h o l d f i e l d m u s t b e n u m e r i c 6 A t % s t h e f o l l o w i n g q u e r y e x e c u t e d i n % l u m i l l i s e c o n d s C o n f i g u r e & C r e a t e a N e w D a t a S o u r c e t o S Q L S e r v e r  < U n a b l e t o d i s p l a y >  s k i p p e d  D a t a S o u r c e N a m e  D a t a S o u r c e N a m e  D a t a S o u r c e D e s c r i p t i o n  D r i v e r  S e r v e r  L o g i n I D  P a s s w o r d  A p p N a m e  W o r k S t a t i o n I D  D a t a b a s e  L a n g u a g e  T r a n s l a t e C h a r a c t e r D a t a  L o g L o n g R u n n i n g Q u e r i e s  Q u e r y L o g F i l e  Q u e r y L o g T i m e  L o g D r i v e r S t a t i s t i c s  S t a t i s t i c s F i l e  U s e I n t e g r a t e d S e c u r i t y  U s e R e g i o n a l S e t t i n g s  P r e p a r e d S t a t e m e n t s O p t i o n  U s e F a i l o v e r S e r v e r  U s e A N S I Q u o t e d I d e n t i f i e r s $ U s e A N S I N u l l , P a d d i n g s a n d W a r n i n g s  A t t a c h D a t a b a s e F i l e n a m e  D a t a E n c r y p t i o n  R o w  C o l u m n 7 M i c r o s o f t S Q L S e r v e r O D B C D r i v e r V e r s i o n % 0 2 u . % 0 2 u . % 0 4 u " D o n o t c r e a t e t e m p o r a r y p r o c e d u r e s ' D r o p t e m p o r a r y p r o c e d u r e s o n d i s c o n n e c t $ E x p l i c i t l y d r o p t e m p o r a r y p r o c e d u r e s  R u n n i n g c o n n e c t i v i t y t e s t s . . .  A t t e m p t i n g c o n n e c t i o n  C o n n e c t i o n e s t a b l i s h e d  V e r i f y i n g o p t i o n s e t t i n g s  D i s c o n n e c t i n g f r o m s e r v e r  T E S T S C O M P L E T E D S U C C E S S F U L L Y !
T E S T S F A I L E D ! ! T h e d a t a b a s e e n t e r e d i s n o t v a l i d : ' P e r f o r m t r a n s l a t i o n f o r c h a r a c t e r d a t a ' s h o u l d b e c h e c k e d  U n k n o w n N e t E r r .  I n s u f f i c i e n t m e m o r y .  A c c e s s d e n i e d .  C o n n e c t i o n i s b u s y .  C o n n e c t i o n b r o k e n .  C o n n e c t i o n l i m i t e x c e e d e d .  S p e c i f i e d S Q L s e r v e r n o t f o u n d . ! T h e n e t w o r k h a s n o t b e e n s t a r t e d .  I n s u f f i c i e n t n e t w o r k r e s o u r c e s .  N e t w o r k i s b u s y .  N e t w o r k a c c e s s d e n i e d . 8 G e n e r a l n e t w o r k e r r o r . C h e c k y o u r n e t w o r k d o c u m e n t a t i o n .  I n c o r r e c t c o n n e c t i o n m o d e . $ N a m e n o t f o u n d i n d i r e c t o r y s e r v i c e .  I n v a l i d c o n n e c t i o n . & E r r o r r e a d i n g o r w r i t i n g n e t w o r k d a t a .  T o o m a n y o p e n f i l e h a n d l e s . + S Q L S e r v e r d o e s n o t e x i s t o r a c c e s s d e n i e d .  S S L S e c u r i t y e r r o r ! S Q L S e r v e r r e q u i r e s E n c r y p t i o n O n & E n c r y p t i o n n o t s u p p o r t e d o n S Q L S e r v e r  sqlsrv32




Partial of:

instcat.sql






go
dump tran master with no_log
go
create procedure sp_indexes_rowset;5
(
@table_server sysname,
@table_catalog sysname = null,
@table_name sysname = null,
@index_name sysname = null,
@table_schema sysname = null
)
as
select
TABLE_CATALOG,
TABLE_SCHEMA,
TABLE_NAME,
INDEX_CATALOG,
INDEX_SCHEMA,
INDEX_NAME,
PRIMARY_KEY,
"UNIQUE",
"CLUSTERED",
"TYPE",
FILL_FACTOR,
INITIAL_SIZE,
NULLS,
SORT_BOOKMARKS,
AUTO_UPDATE,
NULL_COLLATION,
ORDINAL_POSITION,
COLUMN_NAME,
COLUMN_GUID,
COLUMN_PROPID,
COLLATION,
CARDINALITY,
PAGES,
FILTER_CONDITION
-- INTEGRATED
from master.dbo.SYSREMOTE_INDEXES (
@table_server,
@table_catalog,
@table_schema,
@index_name,
NULL, /* TYPE (index type) */
@table_name )
order by 8 desc, 4, 5, 6, 17
go

grant execute on sp_indexes_rowset to public
go

dump tran master with no_log
go

if (charindex('8.00', @@version) > 0)
drop procedure sp_indexes_rowset
else
begin
print ''
print ''
print 'Warning:'
print 'you are installing the stored procedures '
print 'on a pre 8.0 SQL Server.'
print 'Ignore the following errors.'
end
go

/* 8.0 version */
create procedure sp_indexes_rowset
(
@table_name sysname,
@index_name sysname = null,
@table_schema sysname = null
)
as
select TABLE_CATALOG = db_name(),
TABLE_SCHEMA = user_name(o.uid),
TABLE_NAME = o.name,
INDEX_CATALOG = db_name(),
INDEX_SCHEMA = user_name(o.uid),
INDEX_NAME = x.name,
PRIMARY_KEY = convert(bit,(x.status & 0x800)/0x800),
"UNIQUE" = convert(bit,(x.status & 2)/2),
"CLUSTERED" = convert(bit,(x.status & 16)/16),
"TYPE" = convert(smallint, 1 /*DBPROPVAL_IT_BTREE*/),
FILL_FACTOR = convert(int, x.OrigFillFactor),
INITIAL_SIZE = convert(int,null),
NULLS = convert(int,null),
SORT_BOOKMARKS = convert(bit,0),
AUTO_UPDATE = convert(bit,1),
NULL_COLLATION = convert(int,4 /*DBPROPVAL_NC_LOW*/),
ORDINAL_POSITION = convert(int, xk.keyno),
COLUMN_NAME = c.name,
COLUMN_GUID = convert(uniqueidentifier,null),
COLUMN_PROPID = convert(int,null),
COLLATION = convert(smallint,
case when indexkey_property(o.id, x.indid, xk.keyno, 'IsDescending') =1
then 2 /* DB_COLLATION_DESC */
else 1 /* DB_COLLATION_ASC */
end),
CARDINALITY = case when (x.status & 2) = 2 then x.rows else null end,
PAGES = convert(int, x.dpages),
FILTER_CONDITION = convert(nvarchar(1),null),
INTEGRATED = convert(bit,(x.status & 16)/16)

from sysobjects o, sysindexes x, syscolumns c, sysindexkeys xk
where o.type in ('U')
and o.name = @table_name
and (@table_schema is null or @table_schema = user_name(o.uid))
and (@index_name is null or @index_name = x.name)
and x.id = o.id
and o.id = c.id
and o.id = xk.id
and x.indid = xk.indid
and c.colid = xk.colid
and xk.keyno <= x.keycnt
and permissions(o.id, c.name) <> 0
and (x.status&32) = 0 -- No hypothetical indexes
order by 8 desc, 4, 5, 6, 17
go
dump tran master with no_log
go
create procedure sp_indexes_rowset;2
(
@index_name sysname = null,
@table_schema sysname = null
)
as
select TABLE_CATALOG = db_name(),
TABLE_SCHEMA = user_name(o.uid),
TABLE_NAME = o.name,
INDEX_CATALOG = db_name(),
INDEX_SCHEMA = user_name(o.uid),
INDEX_NAME = x.name,
PRIMARY_KEY = convert(bit,(x.status & 0x800)/0x800),
"UNIQUE" = convert(bit,(x.status & 2)/2),
"CLUSTERED" = convert(bit,(x.status & 16)/16),
"TYPE" = convert(smallint, 1 /*DBPROPVAL_IT_BTREE*/),
FILL_FACTOR = convert(int, x.OrigFillFactor),
INITIAL_SIZE = convert(int,null),
NULLS = convert(int,null),
SORT_BOOKMARKS = convert(bit,0),
AUTO_UPDATE = convert(bit,1),
NULL_COLLATION = convert(int,4 /*DBPROPVAL_NC_LOW*/),
ORDINAL_POSITION = convert(int, xk.keyno),
COLUMN_NAME = c.name,
COLUMN_GUID = convert(uniqueidentifier,null),
COLUMN_PROPID = convert(int,null),
COLLATION = convert(smallint,
case when indexkey_property(o.id, x.indid, xk.keyno, 'IsDescending') =1
then 2 /* DB_COLLATION_DESC */
else 1 /* DB_COLLATION_ASC */
end),
CARDINALITY = case when (x.status & 2) = 2 then x.rows else null end,
PAGES = convert(int, x.dpages),
FILTER_CONDITION = convert(nvarchar(1),null),
INTEGRATED = convert(bit,(x.status & 16)/16)

from sysobjects o, sysindexes x, syscolumns c, sysindexkeys xk
where o.type in ('U')
and (@table_schema is null or @table_schema = user_name(o.uid))
and (@index_name is null or @index_name = x.name)
and x.id = o.id
and o.id = c.id
and o.id = xk.id
and x.indid = xk.indid
and c.colid = xk.colid
and xk.keyno <= x.keycnt
and permissions(o.id, c.name) <> 0
and (x.status&32) = 0 -- No hypothetical indexes
order by 8 desc, 4, 5, 6, 17
go
dump tran master with no_log
go
create procedure sp_indexes_rowset;5
(
@table_server sysname,
@table_catalog sysname = null,
@table_name sysname = null,
@index_name sysname = null,
@table_schema sysname = null
)
as
select
TABLE_CATALOG,
TABLE_SCHEMA,
TABLE_NAME,
INDEX_CATALOG,
INDEX_SCHEMA,
INDEX_NAME,
PRIMARY_KEY,
"UNIQUE",
"CLUSTERED",
"TYPE",
FILL_FACTOR,
INITIAL_SIZE,
NULLS,
SORT_BOOKMARKS,
AUTO_UPDATE,
NULL_COLLATION,
ORDINAL_POSITION,
COLUMN_NAME,
COLUMN_GUID,
COLUMN_PROPID,
COLLATION,
CARDINALITY,
PAGES,
FILTER_CONDITION
-- INTEGRATED
from master.dbo.SYSREMOTE_INDEXES (
@table_server,
@table_catalog,
@table_schema,
@index_name,
NULL, /* TYPE (index type) */
@table_name )
order by 8 desc, 4, 5, 6, 17
go

grant execute on sp_indexes_rowset to public
go

dump tran master with no_log
go
if (charindex('6.00', @@version) > 0)
begin
if (exists (select * from sysobjects
where name = 'sp_indexes_rowset' and type = 'P '))
begin
drop procedure sp_indexes_rowset
dump tran master with no_log
end
end
go


print ''
print 'creating sp_primary_keys_rowset'
go

/* Procedure for 6.0 and 6.5 servers */
create procedure sp_primary_keys_rowset
(
@table_name varchar(255),
@table_schema varchar(244) = null
)
as
select TABLE_CATALOG = db_name(),
TABLE_SCHEMA = user_name(o.uid),
TABLE_NAME = o.name,
COLUMN_NAME = c.name,
COLUMN_GUID = convert(binary(16),null),
COLUMN_PROPID = convert(int,null),
ORDINAL = convert(int,
case
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 1) then 1
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 2) then 2
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 3) then 3
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 4) then 4
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 5) then 5
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 6) then 6
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 7) then 7
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 8) then 8
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 9) then 9
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 10) then 10
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 11) then 11
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 12) then 12
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 13) then 13
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 14) then 14
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 15) then 15
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 16) then 16
end
),
PK_NAME = i.name
from sysindexes i, syscolumns c, sysobjects o, sysusers u
where o.type in ('U')
and o.name = @table_name
and (@table_schema is null or @table_schema = user_name(o.uid))
and o.id = c.id
and o.id = i.id
and (i.status & 0x800) = 0x800
and (c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 1) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 2) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 3) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 4) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 5) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 6) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 7) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 8) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 9) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 10) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 11) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 12) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 13) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 14) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 15) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 16)
)
and u.uid = user_id() /* constrain sysusers uid for use in subquery */
and (
suser_id() = 1 /* User is the System Administrator */
or o.uid = user_id() /* User created the object */
/* here's the magic... select the highest precedence of permissions in the order (user,group,public) */
or ( (select max(((sign(uid)*abs(uid-16383))*2)+(protecttype&1))
from sysprotects p
where p.id = o.id
/* get rows for public,current user,user's group */
and (p.uid = 0 or p.uid = user_id() or p.uid = u.gid)
/* check for SELECT,EXECUTE privilege */
and (action in (193,224)))&1 /* more magic...normalize GRANT */
) = 1 /* final magic...compare Grants */
)
order by 2, 3
go
dump tran master with no_log
go
create procedure sp_primary_keys_rowset;2
(
@table_schema varchar(244) = null
)
as
select TABLE_CATALOG = db_name(),
TABLE_SCHEMA = user_name(o.uid),
TABLE_NAME = o.name,
COLUMN_NAME = c.name,
COLUMN_GUID = convert(binary(16),null),
COLUMN_PROPID = convert(int,null),
ORDINAL = convert(int,
case
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 1) then 1
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 2) then 2
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 3) then 3
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 4) then 4
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 5) then 5
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 6) then 6
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 7) then 7
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 8) then 8
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 9) then 9
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 10) then 10
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 11) then 11
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 12) then 12
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 13) then 13
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 14) then 14
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 15) then 15
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 16) then 16
end
),
PK_NAME = i.name
from sysindexes i, syscolumns c, sysobjects o, sysusers u
where o.type in ('U')
and (@table_schema is null or @table_schema = user_name(o.uid))
and o.id = c.id
and o.id = i.id
and (i.status & 0x800) = 0x800
and (c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 1) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 2) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 3) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 4) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 5) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 6) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 7) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 8) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 9) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 10) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 11) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 12) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 13) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 14) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 15) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 16)
)
and u.uid = user_id() /* constrain sysusers uid for use in subquery */
and (
suser_id() = 1 /* User is the System Administrator */
or o.uid = user_id() /* User created the object */
/* here's the magic... select the highest precedence of permissions in the order (user,group,public) */
or ( (select max(((sign(uid)*abs(uid-16383))*2)+(protecttype&1))
from sysprotects p
where p.id = o.id
/* get rows for public,current user,user's group */
and (p.uid = 0 or p.uid = user_id() or p.uid = u.gid)
/* check for SELECT,EXECUTE privilege */
and (action in (193,224)))&1 /* more magic...normalize GRANT */
) = 1 /* final magic...compare Grants */
)
order by 2, 3
go

if (charindex('7.00', @@version) = 0 and
charindex('8.00', @@version) = 0)
begin
print ''
print ''
print 'Warning:'
print 'you are installing the stored procedures '
print 'on a pre 8.0 SQL Server.'
print 'Ignore the following errors.'
end
else
drop proc sp_primary_keys_rowset
go

/* Procedure for 7.0 & 8.0 servers */
create procedure sp_primary_keys_rowset
(
@table_name sysname,
@table_schema sysname = null
)
as
select TABLE_CATALOG = db_name(),
TABLE_SCHEMA = user_name(o.uid),
TABLE_NAME = o.name,
COLUMN_NAME = c.name,
COLUMN_GUID = convert(uniqueidentifier,null),
COLUMN_PROPID = convert(int,null),
ORDINAL = convert(int,
case
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 1) then 1
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 2) then 2
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 3) then 3
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 4) then 4
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 5) then 5
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 6) then 6
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 7) then 7
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 8) then 8
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 9) then 9
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 10) then 10
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 11) then 11
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 12) then 12
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 13) then 13
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 14) then 14
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 15) then 15
when c.name = index_col(user_name(o.uid)+'.'+o.name, i.indid, 16) then 16
end
),
PK_NAME = i.name
from sysindexes i, syscolumns c, sysobjects o
where o.type in ('U')
and o.name = @table_name
and (@table_schema is null or @table_schema = user_name(o.uid))
and o.id = c.id
and o.id = i.id
and (i.status & 0x800) = 0x800 -- PRIMARY KEY
and (c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 1) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 2) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 3) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 4) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 5) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 6) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 7) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 8) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 9) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 10) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 11) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 12) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 13) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 14) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 15) or
c.name = index_col (user_name(o.uid)+'.'+o.name, i.indid, 16)
)
and permissions(o.id) <> 0
order by 2, 3
go
dump tran master with no_log
go
create procedure sp_primary_keys_rowset;2
(
@table_schema sysname = null
)
as



There is much more...
Posted Image

BC AdBot (Login to Remove)

 


#2 DevilsKnight

DevilsKnight
  • Topic Starter

  • Members
  • 3 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:10:59 AM

Posted 18 June 2011 - 03:51 PM

Apologies for not posting the combofix etc. logs atm.. plz dont delete and take everything into consideration. thank you
Posted Image

#3 boopme

boopme

    To Insanity and Beyond


  • Global Moderator
  • 73,566 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:NJ USA
  • Local time:12:59 PM

Posted 18 June 2011 - 10:43 PM

Hello having run ComboFix we need to see that and a DDS log.

Please go here....
Preparation Guide .

Create a DDS log and post it in the new topic explained in step 9 which is here Virus, Trojan, Spyware, and Malware Removal Logs and not in this topic,thanks.
Skip the GMER step and instead post the ComboFix log you have.

Let me know if that went well.
How do I get help? Who is helping me?For the time will come when men will not put up with sound doctrine. Instead, to suit their own desires, they will gather around them a great number of teachers to say what their itching ears want to hear....Become a BleepingComputer fan: Facebook




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users