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!
Navigation:
[Reply to this message]
|