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 best institute to Learn DotNET And SQL in chennai?

0 Answers  

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  

Explain the new features of SQL server 2000?

1 Answers  




explain query execution plan

1 Answers  

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

What is optimistic concurrency?

0 Answers  

What is an Index?

3 Answers   Yardi Software,

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

What do you mean by data manipulation language?

0 Answers  

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories