Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am having trouble with my SQL Server 2008 R2 instance.

First, one of my databases on this instance seems to have crashed. When I try to drop it, I am getting the error message below.

Msg 3702, Level 16, State 3, Line 2

Cannot drop database “DataBaseName” because it is currently in use.

I needed to drop the crashed database and recreate it from scratch. I couldn't rename it either.

Now I try to restart the instance and it seems to hung, with the State column showing 'change pending...'

What's acting up?

share|improve this question

Sounds like a large change is being made to a table's schema.

When you view the database in SQL Server Management Studio's object explorer, what does it say next to the database?

If you delete the database from the object explorer there should be a check box you can click that will automatically close all the connections to the database before dropping it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.