| Author |
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?
| |
| Kalen Delaney 2005-05-30, 8:23 pm |
| 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...
>
>
>
| |
| Kalen Delaney 2005-05-31, 3:23 am |
| 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...[color=darkred]
> On all databases including masters, model and or users databases. On the
> other sqlserver instances I have no such issue?!?!?!?
>
> "Kalen Delaney" wrote:
>
|
|
|
|