adspace


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


Please Help Members By Posting Answers For Below Questions

How can we solve concurrency problems?

1121


Does view occupy space?

1018


What are the different SQL Server Versions you have worked on?

1077


What is sql or structured query language?

1226


Explain system functions or built-in functions? What are different types of system functions?

1063


What is the primary use of the model database?

1147


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8227


Can we do dml on views?

1035


Can one drop a column from a table?

1086


What is a coalesce function?

1282


Where can you add custom error messages to sql server?

1207


What kind of problems occurs if we do not implement proper locking strategy?

1499


What is temporary table in sql server? Why we use temp table?

1017


Why should you use or avoid select * statements?

1108


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132