How to fix orphaned users in SQL
Posted by elberon5 Fri, 16 Feb 2007 05:32:00 GMT
In query analyzer :
exec
sp_change_users_login 'Auto_Fix','UserName'
Now this was the old way. You ended up with orphaned users when you transfer databases between SQL Servers using the old Backup/Restore trick. You bring over users from the one server, that don't map properly to the same user in the new database server.
The New Method - this one lets you move em between 2k5 and 2000 and vice-versa
Database Publishing Wizard.
-enjoy
Comments
Leave a response