1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / chaithanya

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / karthik

Orphan User : NO login id or password are 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)

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is sql server 2016 free?

0 Answers  

Is there any difference between primary key and unique with the not null condition?

0 Answers  

What is database mirroring?

0 Answers  

What is model database? : SQL Server Architecture

0 Answers  

What is the difference between insensitive and scroll cursor?

0 Answers  




What are dml (data manipulation language) statements in ms sql server?

0 Answers  

role of sql sever 2005 in database rather than any other database

0 Answers  

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

Can you roll back the ddl statement in a trigger?

0 Answers  

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

What is the difference between locking and multi-versioning?

0 Answers  

1 01 101 01010

0 Answers  

For more SQL Server Interview Questions Click Here
Categories