What do u mean by orphan users, how will u list them in the
DB

Answers were Sorted based on User's Feedback



What do u mean by orphan users, how will u list them in the DB..

Answer / 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

What do u mean by orphan users, how will u list them in the DB..

Answer / 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

More SQL Server Interview Questions

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  


What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,


What's the difference between a primary key and a unique key?

4 Answers  


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  






What are the types of database schema? : sql server analysis services, ssas

0 Answers  


What is user stored procedure & it purpose?

4 Answers   Wipro,


Explain magic tables in sql server?

0 Answers  


What is a trace frag?

0 Answers  


What is subquery in sql?

0 Answers  


What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,


What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,


Categories