What do u means by orphan users, how u will list them in the DB?



Orphan User: NO login id or password is not associated
With user.

exec sp_change_users_login 'Report' (It helps to find the
orphan user)

Exec sp_change_user_login 'auto_fix','loginname',null(It
helps to map the user with login) 

exec sp_change_users_login 'Report' 

Running the following query on destination server where 
database as been moved to list orphan user

Comments

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)