Aquila

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)

Aquila

woop forgot to mention that its sql server 2000

GMan_NC

Yes, in Enterprise Manager, right click a DB and select All Tasks ---> Import Data. Then go through the wizard and try it that way

Aquila

sweet
thanks