TRUNCATE an FK

Rollback or Not?

Truncate a table that has foreign keys referencing its columns

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

Grant Truncate Table Permissions in SQL Server without ALTER Table

How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.

TRUNCATE

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.

Truncate All Tables Part 2

Restore relationships between tables