If you restore database,there are scenarios when our user gets orphaned.
USE myDb
EXEC sp_change_users_login 'Report'
If you do have orphaned users, you can restore them if they exist but they are not linked to actual logins.
EXEC sp_change_users_login 'Auto_Fix', 'user'
USE myDb
EXEC sp_change_users_login 'Report'
If you do have orphaned users, you can restore them if they exist but they are not linked to actual logins.
EXEC sp_change_users_login 'Auto_Fix', 'user'
No comments:
Post a Comment