declare @len varchar(8000)
set @len=''
select @len = @len + 'truncate ' + name  + char(10)+ char(13) from sys.tables
print @len

---

Ignat Andrei
http://serviciipeweb.ro/iafblog