Capture existing table

[William F. O'Neill]

I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
it. When I did, my database(DEV_DA TA) 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.

[Steve Jorgensen]

Re: Capture existing table

Have you tried attaching the database?

On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
<wfoneill@bells outh.net> wrote:
[color=blue]
>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>it. When I did, my database(DEV_DA TA) 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.
>[/color]

[William F. O'Neill]

Re: Capture existing table

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:no3qj0hlgn 4pmp743j6pmm18n e733ao1j6@4ax.c om...[color=blue]
> Have you tried attaching the database?
>
> On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> <wfoneill@bells outh.net> wrote:
>[color=green]
>>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>>it. When I did, my database(DEV_DA TA) 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.
>>[/color]
>[/color]

[Greg D. Moore \(Strider\)]

Re: Capture existing table


"William F. O'Neill" <wfoneill@bells outh.net> wrote in message
news:zCb%c.7450 7$N11.62157@big news5.bellsouth .net...[color=blue]
> Hi Steve:
>
> Thank you for replying. Using EM, how would I attach, since I don't see[/color]
my[color=blue]
> database in the tree at all. All the other databases are there from the
> installation, eg. Master, Tempdb, Northwind, etc.
>[/color]

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.

[color=blue]
>
> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
> news:no3qj0hlgn 4pmp743j6pmm18n e733ao1j6@4ax.c om...[color=green]
> > Have you tried attaching the database?
> >
> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> > <wfoneill@bells outh.net> wrote:
> >[color=darkred]
> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to[/color][/color][/color]
reinstall[color=blue][color=green][color=darkred]
> >>it. When I did, my database(DEV_DA TA) 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[/color][/color][/color]
database[color=blue][color=green][color=darkred]
> >>included.
> >>[/color]
> >[/color]
>
>[/color]

[William F. O'Neill]

Re: Capture existing table

Thank you, Greg. Will give it a try!.


"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co m> wrote in message
news:f3c%c.1304 4$2s.12051@twis ter.nyroc.rr.co m...[color=blue]
>
> "William F. O'Neill" <wfoneill@bells outh.net> wrote in message
> news:zCb%c.7450 7$N11.62157@big news5.bellsouth .net...[color=green]
>> Hi Steve:
>>
>> Thank you for replying. Using EM, how would I attach, since I don't see[/color]
> my[color=green]
>> database in the tree at all. All the other databases are there from the
>> installation, eg. Master, Tempdb, Northwind, etc.
>>[/color]
>
> 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.
>
>[color=green]
>>
>> "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
>> news:no3qj0hlgn 4pmp743j6pmm18n e733ao1j6@4ax.c om...[color=darkred]
>> > Have you tried attaching the database?
>> >
>> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
>> > <wfoneill@bells outh.net> wrote:
>> >
>> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to[/color][/color]
> reinstall[color=green][color=darkred]
>> >>it. When I did, my database(DEV_DA TA) 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[/color][/color]
> database[color=green][color=darkred]
>> >>included.
>> >>
>> >[/color]
>>
>>[/color]
>
>[/color]