Copying Data Structures and Stored Procedures

01-09-2003, 08:40 AM
I have a database with over 1500 stored procedures and 50 tables, I need to make a blank copy of this database, where all the tables are empty.

I thought about just detaching and reataching under a different name, but to go through each table and delete the several hundred thousand rows of data would be time consuming.

Is there any way anyone knows of that I could just copy the 1500 stored procedures to a new database (the create table procedures are still there so I could run them easily)

01-09-2003, 08:44 AM
woop forgot to mention that its sql server 2000

01-09-2003, 08:48 AM
Yes, in Enterprise Manager, right click a DB and select All Tasks ---> Import Data. Then go through the wizard and try it that way

01-09-2003, 09:04 AM

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum