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
- 6570 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 to assign new column names in a view?
Describe in brief system database.
What is the difference between locking and multi-versioning?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Distinguish between commit and rollback?
Can I use sql azure as a backup with log shipping or database mirroring?
Write SQL queries on Self Join and Inner Join.
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How can you know if the row fetched from cursor is still valid in underlying table?
How you can change a cross join into an inner join?
What is co-related sub query?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Write a query for primary key constraint with identity key word?
How to find which stored procedure is currently running in sql server?
