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
- 6600 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
how you can get the list of largest tables in a database? : Sql server administration
What is difference between views and stored procedures?
Explain Normalization and DE normalization
What is set nocount on?
How to rebuild all indexes on a single table?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is normalization? Explain different forms of normalization?
What is a bit datatype?
What is the use of set nocount on/off statement?
Where are stored procedures in sql server?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is the importance of a recovery model?
How can you list all the columns in a database?
How can I add Reporting Services reports to my application?
When I run the sql server 2000 setup, it just hangs. What do I do?
