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?
Monday, February 13, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment