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 |
How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.
How will you Handle Error in SQL SERVER 2008?
In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?
Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?
Difference between Bookmark lookup & RID lookup?
What is Mutex error in Triggers?
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.
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
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.
How many types of internal joins are there in SQL Server?
definion of tcp
What is SCD (Slowly Changing Dimensions)? What are its types?