Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-07-22 : 19:00:03
|
| Hi,SQL Server 2005 Standard Edition 32 bits/Windows 2003 32 bits.I am extracting login using sp_help_revlogin sp. I set output to a text file. When sp runs, text file have long list of create login ..........but at the end of each create login statement there is [SQLSTATE 01000]. When I run this script it gives error that sqlstate 01000 is unrecognized words in statement. When I remove these two words from each create login statement, it runs fine.When I run the same sp from query analyzer, script is fine and these two words ([SQLSTATE 01000]) are not there? How to remove extra words ([SQLSTATE 01000]) from this script. Or how to modify sp_help_revlogin sp to avoid these extra words in login create script generated as text file from job step.Thanks |
|
|
|
|
|
sp_help_revlogin output