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
How to get the query of a table in sql server?
Difference between Logical Page and Physical Page in SSRS.
What is transaction server implicit?
How to sort query output in descending order in ms sql server?
Can you explain what is sql server english query?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is log in sql server?
What is user-defined scalar function?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Define indexes?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Sql server reporting services vs. Crystal reports.
What is the tcp/ip port on which sql server runs?
Why and when do stored procedure recompile?