Can't Detach Database

[bolasete]

on my sql 7 server i just noticed that the option to detach a database is greyed out on my db's.

now i tried switching them to single user mode and that did not work either. i'm logged in as sa so i'm wondering if anyone knows what might be up.

 

[tlbroadbent]

Which database do you want to detach? Is it a user or system database? If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[stephh]

You can check if someone is connecting to the DB.

 

[administratorx]

Make sure that it is not in use by the application.

Administratorx