Extracting Logins From SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Hugh Scott » Extracting Logins From SQL Server

Extracting Logins From SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Hugh Scott

Posted Friday, January 15, 2010 1:07 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 10:02 AM
Points: 398, Visits: 151

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

Post #848111

2 Tim 3:16

Posted Wednesday, January 27, 2010 7:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 23, 2013 1:50 PM
Points: 1,081, Visits: 1,454

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

Post #854355

Darwin101

Posted Wednesday, January 27, 2010 7:34 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:11 PM
Points: 18, Visits: 399

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'.

Post #854388

Rick Todd

Posted Wednesday, January 27, 2010 8:21 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:53 AM
Points: 216, Visits: 418

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

Post #854433

« Prev Topic | Next Topic »

Permissions