use database
declare @TableName nvarchar(100)
declare @Qry nvarchar(500)
declare TrunTable cursor for
select name from Sysobjects where name like '%log'
open TrunTable
fetch next from TrunTable into @tableName
while @@fetch_status = 0
begin
set @qry = 'truncate table ' + @TableName
exec sp_executesql @qry
fetch next from TrunTable into @tableName
end
close TrunTable
deallocate TrunTable
use database
declare @TableName nvarchar(100)
declare @Qry nvarchar(500)
declare TrunTable cursor for
select name from Sysobjects where name like '%log'
open TrunTable
fetch next from TrunTable into @tableName
while @@fetch_status = 0
begin
set @qry = 'truncate table ' + @TableName
exec sp_executesql @qry
fetch next from TrunTable into @tableName
end
close TrunTable
deallocate TrunTable
--
--
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.· Smiling!
`·.¸.·´
M.Karthikk
