What is the diffrence between update_one and auto_fix?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the ways to controlling cursor behavior?
what is memory-optimized nonclustered indexes
How to retrieve error messages using mssql_get_last_message()?
Can a table be moved to different filegroup?
How to create a trigger for insert only?
Explain partitioned view?
What is the difference between SQL notification and SQL invalidation?
What is default constraint?
What is statement level trigger?
How do users use Report Builder with SQL Server data sources?
Explain what are various ways to enhance the ssrs report?
What is dbcc updateusage?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
How to use values from other tables in update statements in ms sql server?
Why I am getting this error when dropping a database in ms sql server?