Run sp_who2 in QA and find out what is using it. If you simple have the
DB selected in EM then you are using it, or if you have open in one of
your QA windows then you are using it.

-----Original Message-----
From: Zelli Brian
[mailto:mssqldba-ezmlmshield-x75817021.[Email address protected]
Sent: Thursday, April 27, 2006 10:35 AM
To: LazyDBA Discussion
Subject: sp_detach

Ok, I am trying to detach a test database and when I execute the command


Exec sp_detach_db 'test2'

It tells me that the db is in use. Nobody is using it. What am I doing
wrong?

Brian


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.


MS Sql Server LazyDBA home page