What is the diffrence between update_one and auto_fix?
Answer Posted / 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 |
Post New Answer View All Answers
Call by value and call by reference in procedure and function, with NOCOPY.
Tell me what is use of except clause? How it differs from not in clause?
List out what other servers you can use with ssrs?
What is transaction server distributed transaction?
What stored by the msdb? : sql server database administration
How to run sql server 2005 books online on your local system?
What is the maximum size of column in sql server?
Explain index in sql server?
Which language rdl files made of?
Do you know what is a with(nolock)?
How to connect ms access to sql servers through odbc?
What is the purpose of linked server configuration in sql server?
How many triggers are possible per table?
Explain following error properties?
What are transactions in sql?