|
I don't need this too often - but when I need it I usually need it fast... and can’t find it in books online… so here is my reminder. Now where are those car keys?
http://msdn2.microsoft.com/en-us/library/ms174378.aspx
Use sp_change_users_login to link a database user in the current database with a SQL Server login. If the login for a user has changed, use sp_change_users_login to link the user to the new login without losing user permissions. The new login cannot be sa, and the user cannot be dbo, guest, or an INFORMATION_SCHEMA user.
EXEC sp_change_users_login 'Report';
|