SQL Server - fix up user login after restoring a database

After restoring a database, you may need to fix up the user login mapping (since the database is moving to a different instance of SQL Server)


EXEC sp_change_users_login 'Report'
EXEC sp_change_users_login 'Auto_Fix', 'licensing'


where licensing is the user login name

Comments