What do u mean by orphan users, how will u list them in the
DB
Answer Posted / 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 View All Answers
What is SQL Azure?
How to set database to be single_user in ms sql server?
What is 2nf normalization form?
What is temporal table?
What do you mean by table and field in sql?
Does sql server 2000 clustering support load balancing?
What is meant by indexing files?
What is cursors?
What is a heap?
How do I run a trace in sql server?
Can a table be moved to different filegroup?
What is sql view?
What are pages and extents? : SQL Server Architecture
What is the purpose of grouping data in a report?
What is TDS(Tabular Data Stream) Gateway?