Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?

Answer Posted / mandarps

If you want to use DBCC Repair, you need to put the database in single user mode.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write a database figure to implement the master detained relationship.

2445


today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2027


I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1093


How will you Handle Error in SQL SERVER 2008?

1947


What is live lock, deadlock and what is Lock escalation?

1962






why we are using shift key in unix shell script

2600


i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2367


When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2078


How to view the error log for any specific instance?

1957


What is Mutex error in Triggers?

2496


What is the meaning of lock escalation and why/how to stop this?

2181


hp asking for replication floppy to do reinstall 25254 server assistant

2414


What is the use of NOLOCK locking hint?

1378


What is SCD (Slowly Changing Dimensions)? What are its types?

2188


java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6239