SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 04:10 AM
| ||||
| ||||
 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.      |
|
02-29-2008, 04:10 AM
| |||
| |||
| Re: Capture existing table 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. > |
|
02-29-2008, 04:10 AM
| |||
| |||
| 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: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. >> > |
|
02-29-2008, 04:10 AM
| |||
| |||
| Re: Capture existing table "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. > >> > > > > |
|
02-29-2008, 04:10 AM
| ||||
| ||||
| 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. >> >> >> > >> >> > > |
Linear Mode
