1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the diffrence between update_one and auto_fix?

Question Posted / raavi

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

More SQL Server Interview Questions

What is an execution plan? When would you use it?

0 Answers  

Explain about service Broker functions?

0 Answers  

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

how you can list all the tables in a database?

0 Answers  

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  




Can XML be used to access data?

2 Answers  

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

what is database replication? : Sql server database administration

0 Answers  

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

What is row-level compre?

0 Answers  

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

For more SQL Server Interview Questions Click Here
Categories