What is the diffrence between update_one and auto

What is the diffrence between update_one and auto_fix?

Question Posted / raavi

3 Answers
9870 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the diffrence between update_one and auto_fix?..

Answer / aviral nalwat

AUTO_FIX matches based on the user alias in the DB to a
login account.

UPDATE_ONE allows you to specify the alias mapping to the
login account.

See BOL for more detail if needs be.

Is This Answer Correct ?

3 Yes

0 No

What is the diffrence between update_one and auto_fix?..

Answer / karthik

Only members of the sysadmin fixed server role can specify
the Auto_Fix option. Only members of the sysadmin or
db_owner roles can specify the Update_One option.

Is This Answer Correct ?

3 Yes

1 No

What is the diffrence between update_one and auto_fix?..

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