What do u mean by orphan users, how will u list them in the
DB
Answers were Sorted based on User's Feedback
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 |
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 |
How to genrate automaticlly empid like gt001
Can I save my report as html, excel or word? : sql server management studio
Explain about sql server login?
Where the sql logs gets stored? : sql server database administration
Why is normalisation important?
What the difference between UNION and UNIONALL?
how can we use a composite key for two tables and how can we represent it
Can sql server be linked with other servers like oracle?
Can you explain about buffer cash and log cache in sql server?
How many tables can be joined in SQL Server?
What is the xml datatype?
what is Archive old data?