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)@.msn.com> wrote in message
news:FA15395A-8D3A-49C2-98A6-93912DA0C095@.microsoft.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)@.msn.com> wrote in message
> news:FA15395A-8D3A-49C2-98A6-93912DA0C095@.microsoft.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?
>
>|||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)@.msn.com> wrote in message
news:4902C8EF-1179-4BEA-9331-66B8998B6190@.microsoft.com...
> 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)@.msn.com> wrote in message
>> news:FA15395A-8D3A-49C2-98A6-93912DA0C095@.microsoft.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?
>>