Putting db in single_user mode
-
My maintanence plan Integrity check is failing. I ran dbcc checkdb on that db and it showed me 843 consistency errors on one table. It tells me that at the minumum, I need to run dbcc checkdb with repair_allow_data_loss to fix this. So...in order to do that, I need to put the db in single_user mode. I tried this and I get one blocked and one blocked by issue. NT Authority/system is one and sa is the other. It won't go into single_user mode. What is my problem and how do I fix this?????? I even tried the alter database command for setting single_user with rollback immediate and it didn't kill anything......
I need to fix this table issue...any ideas????
-
You have two options:
1. Call the connected users an ask them to close the connections and then run the alter database xxx set single_user with rollback immediate
2. don't be that polite kill all others connections and run the same alter statement
Cheers,
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply