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 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!
October 10, 2007 4:23 PM
October 24, 2007 4:39 PM