Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?
Answers were Sorted based on User's Feedback
Answer / mandar
if you wish to use DBCC Repair, you must first put the database in single user mode otherwise you can run it in normal way
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Mutex error in Triggers?
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.
Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?
What is SCD (Slowly Changing Dimensions)? What are its types?
What are the required/mandatory parameters that have to be passed with RAISEERROR statement?
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
When do you get "getwmicomexception"?
definion of tcp
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.
How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table
What severity level errors are managed in TRY-CATCH block?