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...
>
>|||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...[vbcol=seagreen]
> On all databases including masters, model and or users databases. On the
> other sqlserver instances I have no such issue?!?!?!?
> "Kalen Delaney" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment