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


Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: