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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to change parameter value inside the report?

119


What is the difference between index seek vs. Index scan?

684


How adventureworkslt tables are related?

605


What is scan table/view and seek table/view when its occurs? : sql server database administration

606


What is always encrypted?

595






What is the report model project?

109


What is enhanced database mirroring in sql server 2008?

589


What is an active database?

674


What is the difference between varchar and varchar(max) datatypes?

662


What are “unrepeatable reads”?

820


What is the use of RDBMS?

674


Mention the differences between local and global temporary tables.

651


Describe in brief databases and sql server databases architecture.

603


Where actually sql azure database is hosted?

155


What is a benefit of using an after insert trigger over using a before insert trigger?

604