January 30, 2003 at 9:28 am
I have an old backup of master which contains logins that I need to add to a new production server. What is the best way to retrieve these? I have a test server that can be used to restore the master db to, rather than disturbing the prod server.
Thanks
January 30, 2003 at 9:56 am
January 30, 2003 at 10:01 am
Sorry, yes SQL 2000.
February 12, 2003 at 10:41 am
check out sp_help_revlogin. I've used it on 7.0 instances to move userids (and passwords) between instances.
February 12, 2003 at 10:54 am
By default sp_help_revlogin is not created. Check http://support.microsoft.com/default.aspx?scid=kb;en-us;246133 for the sp.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply