June 13, 2005 at 12:16 pm
After I retored an old database back to my SQL Server 2000. I see that it has few login account in its local sysusers table, but not in the master's sysusers table. I can't use sp_droplogin to drop them (it says they don't exist). When I try to add the same login accounts, it says they already exist.
How do you sync them with the master's syslogins without retoring the master database?
June 13, 2005 at 12:35 pm
Try this link from Microsoft: http://support.microsoft.com/kb/240872/EN-US/ There's also a script somewhere on this site that creates a stored procedure to do the same thing here: http://www.sqlservercentral.com/scripts/contributions/834.asp I've used both methods and they work fine. Good luck.
My hovercraft is full of eels.
June 15, 2005 at 10:30 am
try this.
1. create the missing logins
2. run exec sp_change_users_login 'report' on your user database that you just recovered to obtain a list of orphan logins
3. run exec sp_change_users_login 'update_one','login','login' where login is the logins from step#2
June 15, 2005 at 10:35 am
Thank you! I tried similar steps yesterday and it worked.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply