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
- 6714 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What will be the maximum number of index per table?
Which tcp/ip port does the sql server run on? How can it be changed?
How you can get the list of largest tables in a database?
Can two different columns be merged into single column? Show practically?
When you should use a low fill factor?
What is the function of inner join?
What is b tree index?
What is a DBMS, query, SQL?
What is the use of for clause?
Does a server store data?
What are the limitations/drawbacks or ssrs 2008 r2?
Explain what is lock escalation?
Tell me what are the essential components of sql server service broker?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Can you tell me about the concept of ER diagrams?
