This stored procedure will truncate a table even when other tables have FKs referencing columns in it. It drops the Fks, truncates the table, re-creates the FKs
2017-04-19 (first published: 2017-03-28)
722 reads
Procedure to automatically truncate table partition
2014-09-29 (first published: 2010-02-04)
9,413 reads
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
956 reads
Restore relationships between tables
2011-06-03 (first published: 2008-08-18)
1,070 reads