Browse by Tags

Sorry, but there are no more tags available to filter with.

Truncate All Tables - Part II

There are many methods to truncate all the tables in a database Part I of my post http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/truncate-all-tables-part-i.aspx shows executing the concatenated truncate table statements. This is other method Set NoCount ON Declare @tableName varchar ( 200...

Posted to Madhivanan (Weblog) by Madhivanan on 08-27-2007
Truncate All Tables - Part I

This procedure will truncate all the tables in the database To truncate all tables,I have seen the programmers using Cursors to get all tables and truncate them.This will avoid Cursors. Running this procedure will make SQL Server to slow down other tasks. So test this with test server and make sure that...

Posted to Madhivanan (Weblog) by Madhivanan on 08-27-2007

Page 1 of 1 (2 items)

SQL Server Community Blogs