detach database unavailable

Any ideas why the detach databade option is unavailable
(dimmed out) on my SQL Server 7.0 Standard edition?Hi Jim
Detaching a database from the GUI was not possible in SQL 7. You have to the
stored procedure sp_detach_db.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jim" <jim.abel@.lmco.com> wrote in message
news:56e701c3b2ce$5a6e21c0$a601280a@.phx.gbl...
> Any ideas why the detach databade option is unavailable
> (dimmed out) on my SQL Server 7.0 Standard edition?|||Sorry Nevermind, I forgot that a database cannot be
detached when it is in use. I just didn't realize that
it will dim out the option in EM
>--Original Message--
>Any ideas why the detach databade option is unavailable
>(dimmed out) on my SQL Server 7.0 Standard edition?
>.
>|||I don't have an SQL7 to test on, but as I remember: EM7 didn't expose detach or attach options. And
while EM2000 does, when connecting to an SQL7, the options are not available (as Kalen points out).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jim" <jim.abel@.lmco.com> wrote in message news:0e5401c3b2d0$7b8d37e0$a001280a@.phx.gbl...
> Sorry Nevermind, I forgot that a database cannot be
> detached when it is in use. I just didn't realize that
> it will dim out the option in EM
> >--Original Message--
> >Any ideas why the detach databade option is unavailable
> >(dimmed out) on my SQL Server 7.0 Standard edition?
> >.
> >|||Thanks for the replys, I realized that I would need to
use the query analyzer shortly after my post but
appreciate the confirmation of my ssuspicions.
This post is complete.
Thany you
>--Original Message--
>Hi Jim
>Detaching a database from the GUI was not possible in
SQL 7. You have to the
>stored procedure sp_detach_db.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Jim" <jim.abel@.lmco.com> wrote in message
>news:56e701c3b2ce$5a6e21c0$a601280a@.phx.gbl...
>> Any ideas why the detach databade option is unavailable
>> (dimmed out) on my SQL Server 7.0 Standard edition?
>
>.
>