Posted by hunkgym on 10/10/07 16:26

Good day!

Currently I am using MS SQL Server 2000.

I wish to delete all data in the database table except data in login
table and security table. Furthermore, TRUNCATE is done on stand-alone
and child tables, else DELETE is done if table has any foreign key
references (normally refer to parent tables).

Is there any suggested script/stored procedure to automate the
process?

Thanks a million!

[Back to original message]