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

How to genrate automaticlly empid like gt001

4 Answers  

Can I save my report as html, excel or word? : sql server management studio

0 Answers  

Explain about sql server login?

0 Answers  

Where the sql logs gets stored? : sql server database administration

0 Answers  

Why is normalisation important?

0 Answers  




What the difference between UNION and UNIONALL?

0 Answers   HCL,

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

Can sql server be linked with other servers like oracle?

0 Answers  

Can you explain about buffer cash and log cache in sql server?

0 Answers  

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

What is the xml datatype?

0 Answers  

what is Archive old data?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories