declare @name varchar(100)
declare sysob_cursor cursor
for
select name from sysobjects where type = 'tr'

open sysob_cursor
fetch next from sysob_cursor into @name
print 'if exists (select name from sysobjects where name = '+char(39)+@name+char(39)+' and type = '+char(39)+'tr'+char(39)+')'
print 'drop trigger '+@name
print 'go'
while @@fetch_status = 0
begin
fetch next from sysob_cursor into @name
print 'if exists (select name from sysobjects where name = '+char(39)+@name+char(39)+' and type = '+char(39)+'tr'+char(39)+')'
print 'drop trigger '+@name
print 'go'
end
close sysob_cursor
deallocate sysob_cursor