November 21, 2003 at 2:19 pm
Is there a way to export the SQL Server logins from SQL 6.5 to a script and then re import them to another 6.5 server.
November 24, 2003 at 8:00 am
This was removed by the editor as SPAM
November 24, 2003 at 11:42 am
The best way to export logins is bcp out from master..syslogin to a text file and then go to that file to remove the line for
sa, repl_subscriber and repl_publisher.
Once you remove those 3 lines you could save it and bcp it to a new server. All the password and everything will go to the new server.
mom
November 24, 2003 at 12:17 pm
Will the sp_help_revlogin procedure not work on 6.5? This has saved me several times on 7 & 2000...
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
It doesn't say 6.5 is not supported, but it doesn't say it is either...
-Dan B
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply