select name from sysobjects where xtype='TR'declare @s varchar(8000)
set @s = ''
select @s=@s+' drop trigger '+name from sysobjects where xtype='TR'
set @s = @s+' GO'
exec(@s)
set @s = ''
select @s=@s+' drop trigger '+name from sysobjects where xtype='TR'
set @s = @s+' GO'
exec(@s)
set @sql = ''
select @sql=@sql+' drop trigger '+name from sysobjects where xtype='TR'exec(@s)