DETACH database gray out

Hi gurus
I try to detached a database but the detach entry is gray out thus I cannot
detach the database.

I am logged in as sa , mssql2000 . Right click on the database -> All tasks
-> Detach database ( Gray out ).....

Any idea what is wrong? Why is it gray out?

What database are you trying to detach? If it is a system database, you
cannot detach it.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www. SolidQualityLearning
.com


"dezhi" < wushu_kid(NoSpam)@ms
n.com> wrote in message
news:FA15395A-8D3A-49C2-98A6- 93912DA0C095@microso
ft.com...
> Hi gurus
> I try to detached a database but the detach entry is gray out thus I
> cannot
> detach the database.
>
> I am logged in as sa , mssql2000 . Right click on the database -> All
> tasks
> -> Detach database ( Gray out ).....
>
> Any idea what is wrong? Why is it gray out?

On all databases including masters, model and or users databases. On the
other sqlserver instances I have no such issue?!?!?!?

"Kalen Delaney" wrote:

> What database are you trying to detach? If it is a system database, you
> cannot detach it.
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www. SolidQualityLearning
.com
>
>
> "dezhi" < wushu_kid(NoSpam)@ms
n.com> wrote in message
> news:FA15395A-8D3A-49C2-98A6- 93912DA0C095@microso
ft.com... 
>
>
>

Are you sure the instance you are connecting to is a SQL Server 2000
instance?

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www. SolidQualityLearning
.com


"dezhi" < wushu_kid(NoSpam)@ms
n.com> wrote in message
news:4902C8EF-1179-4BEA-9331- 66B8998B6190@microso
ft.com...
> On all databases including masters, model and or users databases. On the
> other sqlserver instances I have no such issue?!?!?!?
>
> "Kalen Delaney" wrote:
>