Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Truncate Table Rss

Search for any content tagged truncate table

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 7 of 7   
 

Truncate Transaction - All Databases

Script to help you to truncate TL for all databases.  Read more...
By Disney Hammerschmidt 2010/05/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,921 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition   Read more...
By Vidyadhar Pandekar 2014/01/20 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 6,719 reads

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.  Read more...
By Banyardi Schmardi 2009/11/27 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 905 reads

sp_truncate

Truncates referenced tables  Read more...
By Sergey Benner 2009/01/23 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,673 reads

Truncate Referenced Table

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...
By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,241 reads

Truncate All Tables Part 2

Restore relationships between tables  Read more...
By Jorge Novo-@ETLDEVDBA 2011/06/03 | Source: SQLServerCentral.com | Category: truncate table
Rating: (not yet rated) |  Discuss |   Briefcase | 968 reads

Truncate All Tables

Script to Truncate all tables part1  Read more...
By Jorge Novo-@ETLDEVDBA 2011/06/02 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 7,484 reads
   Items 1 to 7 of 7