Interested to Buy Any Domain ? << Click Here >> for more details...
What do u mean by orphan users, how will u list them in the
DB
- 2 Answers
- 6810 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain about integration services of Microsoft SQL server?
How to find the second highest salary of an employee?
What are the difference between “where” and “having” clause in sql server?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
How you can minimize the deadlock situation?
How do I install sql server?
application server is slow what may be the problem
What are the differences between ms sql server & oracle?
What is the distinction amongst delete and truncate?
Mention what are the different types of ssrs reports?
What is usually the first word in a sql query?
How to achieve Paging of records in SQL SERVER?
What is the difference between indexing and hashing?
What is the purpose of update statistics and scope_identity() function?
What is difference between primary key and foreign key?
