Fixing orphaned users in sql
After restoring a db from a model environment to a development environment, the database user was no longer associated with the sql login.
I ran sp_change_users_login 'Report' to get a list of the orphaned users, this return my database user.

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home