I have installed an instance of MSDE. I have a full version of SQLServer2000 and have created all of the procs, etc. and have detached the .mdf file from the full version of SQLServer2000. How do I attach the tables, procs, etc in the MDF file to the MSDE instance?Hi,
Login to SQL Server using OSQL and use sp_attch_db store procedure to attach
the database.
Thanks
Hari
MCDBA
"Tom Buchanan" <thomasfbuchanan@.hotmail.com> wrote in message
news:46FB74F5-46C5-4379-A640-C0F71124D135@.microsoft.com...
> I have installed an instance of MSDE. I have a full version of
SQLServer2000 and have created all of the procs, etc. and have detached the
.mdf file from the full version of SQLServer2000. How do I attach the
tables, procs, etc in the MDF file to the MSDE instance?
Showing posts with label procs. Show all posts
Showing posts with label procs. Show all posts
Subscribe to:
Posts (Atom)