What do u mean by orphan users, how will u list them in the
DB
Answers were Sorted based on User's Feedback
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 |
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 |
can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
What are the steps to follow to configure SQL*Net?
What's the difference between a primary key and a unique key?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is bit datatype and what's the information that can be stored inside a bit column?
What are the types of database schema? : sql server analysis services, ssas
What is user stored procedure & it purpose?
Explain magic tables in sql server?
What is a trace frag?
What is subquery in sql?
What are the types of subscriptions in SQL Server replication?
What is excution Plan in sql server
1 Answers CarrizalSoft Technologies, TCS,