Re: Capture existing table 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.
>> >>
>> >
>>
>>
>
> |