What is the diffrence between update_one and auto_fix?

Answer Posted / manoj pandey

Both are used as 1st param values with sp_change_users_login
s-proc

This is deprecated, should not be used.
more info: http://msdn.microsoft.com/en-us/library/ms174378.aspx

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to defragment table indexes?

546


Explain the various types of concurrency problem?

696


What are the components of sql server service broker?

507


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

566


Explain features of analysis services?

523






What happens if time-only values are provided as date and time literals?

528


What is the maximum length of an alert name?

598


What are the dmvs?

568


What is row_number () and partition by in sql server?

519


What is a dbms wizard?

611


Explain candidate key, alternate key, and composite key?

588


What is Transparent Data Encryption?

585


Difference between Inner vs outer joins?

531


What is encryption key?

84


Is sql server free?

522