Extracting Logins From SQL Server

• Hugh Scott

  SSC Eights!

  Points: 987

  More actions

  January 15, 2010 at 1:07 am

  #214603

  Comments posted to this topic are about the item Extracting Logins From SQL Server

• 2 Tim 3:16

  SSCarpal Tunnel

  Points: 4541

  More actions

  January 27, 2010 at 7:02 am

  #1109260

  sorry, maybe I'm missing something, but I get an error using the 2005 script:

  Msg 102, Level 15, State 1, Line 84

  Incorrect syntax near '?'.

  I can't see what line the error is coming from.

  thanks

  Tim White

• Darwin101

  SSC-Addicted

  Points: 400

  More actions

  January 27, 2010 at 7:34 am

  #1109291

  Msg 102, Level 15, State 1, Line 84

  Incorrect syntax near '?'.

  Msg 102, Level 15, State 1, Line 87

  Incorrect syntax near '?'.

  Msg 102, Level 15, State 1, Line 94

  Incorrect syntax near '?'.

  Msg 156, Level 15, State 1, Line 108

  Incorrect syntax near the keyword 'CLOSE'.

  Msg 102, Level 15, State 1, Line 53

  Incorrect syntax near '?'.

  Msg 156, Level 15, State 1, Line 59

  Incorrect syntax near the keyword 'SET'.

• Rick Todd

  Hall of Fame

  Points: 3302

  More actions

  January 27, 2010 at 8:21 am

  #1109329

  It looks like something is weird with the tabbing. When I removed the indentation from the offending line (in the SQL 2005 script) it worked fine.

  
  Rick Todd

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 18, 2016 at 6:55 am

  #1879823

  Thanks for the script.