select 'alter table '+quotename(s.name)+'.'+quotename(object_name(o.parent_obj))+ ' disable trigger '+quotename(o.name)
from sys.sql_modules m
join sys.sysobjects o on m.object_id=o.id
join sys.schemas s on s.schema_id = o.uid
where o.type='tr'
and definition like '%TABLENAME%'
