Wednesday, August 3, 2011

SQL Server restore

SQL Server - Take Back up  and restore and execute to fix the orphaned users. When u restore u dont find the user in msdb. so u have to execute this  .. (not sure abt this )


exec sp_change_users_login 'auto_fix','UserName',NULL,'Password'

No comments:

Post a Comment