Hi kids... Here's a hot action script for truncating all the tables in your SQL 2005 db for you. Please post your comments, changes, etc. and I'll update this throughout: select distinct t.table_schema + '.' + t.table_name as [table] , case when tc.constraint_type = 'FOREIGN KEY' then 1 else 2 end as [order]into #master_tblfrom information_schema.tables tinner join information_schema.table_constraints tc on tc.table_schema = t.table_schema and tc.table_name = t.table_namewhere t.table_type = 'BASE TABLE'and tc.constraint_type like '% KEY'order by 2alter table #master_tbladd idx bigint identity(1,1)select *into #kfrom #master_tblselect *into #rkfrom #kwhile ((select count(*) from #k) > 0)begin declare @table varchar(1024) declare @idx bigint select top 1 @table = [table] , @idx = idx from #k exec ('alter table ' + @table + ' nocheck constraint all') delete from #k where idx = @idxenddrop table #kselect *into #tfrom #master_tblwhile ((select count(*) from #t) > 0)begin declare @tidx bigint declare @ttable varchar(1024) select top 1 @tidx = idx , @ttable = [table] from #t order by [order] begin try exec('truncate table ' + @ttable) print @ttable + ' purged' end try begin catch print @ttable + ' could not be purged.' end catch delete from #t where idx = @tidxenddrop table #twhile ((select count(*) from #rk) > 0)begin declare @ktable varchar(1024) declare @kidx bigint select top 1 @ktable = [table] , @kidx = idx from #rk exec ('alter table ' + @ktable + ' with check check constraint all') delete from #rk where idx = @kidxenddrop table #rkdrop table #master_tblCheers...