Capture existing table

I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
it. When I did, my database(DEV_DATA) remained intact, but when I go in
thru Enterprise Manager, it is not located in the system tree, and is
therefore inaccessible. Can anyone suggest how I could get this database
included.Have you tried attaching the database?

On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
<wfoneill@.bellsouth.net> wrote:

>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>it. When I did, my database(DEV_DATA) remained intact, but when I go in
>thru Enterprise Manager, it is not located in the system tree, and is
>therefore inaccessible. Can anyone suggest how I could get this database
>included.|||Hi Steve:

Thank you for replying. Using EM, how would I attach, since I don't see my
database in the tree at all. All the other databases are there from the
installation, eg. Master, Tempdb, Northwind, etc.

"Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
> Have you tried attaching the database?
> On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> <wfoneill@.bellsouth.net> wrote:
>>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>>it. When I did, my database(DEV_DATA) remained intact, but when I go in
>>thru Enterprise Manager, it is not located in the system tree, and is
>>therefore inaccessible. Can anyone suggest how I could get this database
>>included.
>|||"William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
news:zCb%c.74507$N11.62157@.bignews5.bellsouth.net. ..
> Hi Steve:
> Thank you for replying. Using EM, how would I attach, since I don't see
my
> database in the tree at all. All the other databases are there from the
> installation, eg. Master, Tempdb, Northwind, etc.

Best bet, don't use EM. Use query analyzer and use sp_attach_db

Otherwise, in EM on the machine in question, right click on databases and
select ALL TASKS and attach Database.

> "Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
> news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
> > Have you tried attaching the database?
> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> > <wfoneill@.bellsouth.net> wrote:
> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to
reinstall
> >>it. When I did, my database(DEV_DATA) remained intact, but when I go in
> >>thru Enterprise Manager, it is not located in the system tree, and is
> >>therefore inaccessible. Can anyone suggest how I could get this
database
> >>included.
> >>|||Thank you, Greg. Will give it a try!.

"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:f3c%c.13044$2s.12051@.twister.nyroc.rr.com...
> "William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
> news:zCb%c.74507$N11.62157@.bignews5.bellsouth.net. ..
>> Hi Steve:
>>
>> Thank you for replying. Using EM, how would I attach, since I don't see
> my
>> database in the tree at all. All the other databases are there from the
>> installation, eg. Master, Tempdb, Northwind, etc.
>>
> Best bet, don't use EM. Use query analyzer and use sp_attach_db
> Otherwise, in EM on the machine in question, right click on databases and
> select ALL TASKS and attach Database.
>
>>
>> "Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
>> news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
>> > Have you tried attaching the database?
>>> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
>> > <wfoneill@.bellsouth.net> wrote:
>>> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to
> reinstall
>> >>it. When I did, my database(DEV_DATA) remained intact, but when I go
>> >>in
>> >>thru Enterprise Manager, it is not located in the system tree, and is
>> >>therefore inaccessible. Can anyone suggest how I could get this
> database
>> >>included.
>> >>
>>>
>>