Aquila
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)
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)