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
Why people hate cursor?
What is a document index?
what are the different ways to return the rowcount of a table?
What is a collation in ms sql server?
How many database files are there in sql server 2000?what are they?
What is the filtered index?
What is SQL Azure?
What are the general features of sql server management studio? : sql server management studio
What is the importance of concurrency control?
How to create stored procedures with parameters in ms sql server?
Does an index slow down updates on indexed columns?
what are user defined datatypes? : Sql server database administration
How we can refresh the view?
Can you index views?
How can you manage sql azure security?