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 many types of built in functions are there in sql server 2012?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is Lock table in SQL?
What is faster join or union?
what are user defined datatypes? : Sql server database administration
What are the properties and different types of sub-queries?
How many types of triggers in sql server?
What are the system database in sql server 2008?
What is the default Port No on which SQL Server listens?
what are the critical issues you have resloved in your company
Write SQL queries on Self Join and Inner Join.
Name and describe few console utilities for ssrs?
What is the native system stored procedure to execute a command against all databases?
System requirements for sql server 2005 express edition?
What is constraints and its types?