You forgot to "kill the users" (Oh my! Phew!).




Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Zelli Brian
[mailto:mssqldba-ezmlmshield-x75817021.[Email address protected]
Sent: Thursday, April 27, 2006 1:35 PM
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

MS Sql Server LazyDBA home page