Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-05-24 : 06:53:37
|
| Hii am trying to give the following command in query browserDBCC CHECKDB ('db1',repair_allow_data_loss) WITH NO_INFOMSGSi am getting the message likeRepair statement not processed. Database needs to be in single user mode.actually no one is accessing the database. but users are accessing another database in the same server. what is the problem, when & how can i use the above commandThanks in advance |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-24 : 06:57:16
|
| The error message tells you the problem -Database needs to be in single user mode.So do that.-------Moo. :) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-24 : 07:00:34
|
| It's saying the database needs to be in in single user mode not just no other users.http://msdn2.microsoft.com/en-us/library/ms188236.aspx==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Pls: DBCC CHECKDB Command