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...
>
>
|||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:

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...
>
>|||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:
>

Design Problem

Hi Gurus
I have seen a desing like this. I found the following problems(?) but I want
comments of Gurus
1)There are four sourse databases(all sql server) and that data is staged
using .exe into another database in another location. This .exe runs windows
bach and inserts data at particular intervels. this data is again marshelled
in to denormalized table from where Notifications are released at different
intervels.
2) the .exe file actullay uses a table in the destination database where all
parameters and related queries are stored to fetch data from source database
s.
Your help is solicited on the following
1) whether .exe is better than sql job with linked server method for
fetching data.
2) Is is right way to store queries in a table than using stored procedure
for that.
can any one tell me pros and cons of both models
--
Thanks in Advance
Regards
SuparichituduWhy not look at DTS? Since you are transferring data between tables and
there is also a step of writing data into de-normalized tables, DTS would
prove quite useful.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Suparichithudu" <Suparichithudu@.discussions.microsoft.com> wrote in message
news:94BC6416-21E5-4FEA-B521-6CC19ABCFDA3@.microsoft.com...
> Hi Gurus
> I have seen a desing like this. I found the following problems(?) but I
> want
> comments of Gurus
> 1)There are four sourse databases(all sql server) and that data is staged
> using .exe into another database in another location. This .exe runs
> windows
> bach and inserts data at particular intervels. this data is again
> marshelled
> in to denormalized table from where Notifications are released at
> different
> intervels.
> 2) the .exe file actullay uses a table in the destination database where
> all
> parameters and related queries are stored to fetch data from source
> databases.
> Your help is solicited on the following
> 1) whether .exe is better than sql job with linked server method for
> fetching data.
> 2) Is is right way to store queries in a table than using stored procedure
> for that.
> can any one tell me pros and cons of both models
> --
> Thanks in Advance
> Regards
> Suparichitudu
>