exec sp_change_users_login 'Report' Running the following query

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

Question Posted / raghu_iteamic

Answer Posted / raghu_iteamic

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

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to set database to be read_only in ms sql server?

980

What is indexed view? How to create it?

969

What information is maintained within the msdb database?

951

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1002

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1025

what is the maximum size of a row? : Sql server database administration

989

Can we write trigger for view?

994

Comment,Datatypes are unlimited

2046

Tell me what is the difference between locking and multi-versioning?

1005

What is the difference between a check constraint and a rule?

1215

How to check if stored procedure is running in sql server?

1023

What are page splits?

986

What is autocommit mode in sql server?

1142

What is the standby server?

937

Explain the difference between cross join and full outer join?

963