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

What the different components of Replication and what is their use?

1068

What is stored procedures?

1035

Do you know data definition language, data control language and data manipulation language?

1040

Detail about the hardware which is supported by SQL server?

1063

What are joins in sql and what are the different types of joins?

1014

What is the partitioning method?

1018

Describe in brief sql server monitoring ways.

1052

Explain user defined views?

963

Please illustrate physical database architecture? : SQL Server Architecture

986

How to link tables in sql server?

935

What are acid properties of transaction?

949

How to recreate an existing index in ms sql server?

1057

Difference between primary key and clustered index?

1007

Explain about local stored procedure?

972

How do you drop an index?

924