SET NOCOUNT ON
GO
SELECT 'ALTER TABLE ' + s.name + '.' + t.name + ' DISABLE TRIGGER ' + tr.name + '
GO' AS DISABLE
FROM sys.tables t
INNER JOIN sys.schemas s ON t.SCHEMA_ID = s.SCHEMA_ID
INNER JOIN sys.triggers tr ON tr.parent_id = t.OBJECT_ID
WHERE tr.is_disabled = 0
GO
SELECT 'ALTER TABLE ' + s.name + '.' + t.name + ' ENABLE TRIGGER ' + tr.name + '
GO' AS Enable
FROM sys.tables t
INNER JOIN sys.schemas s ON t.SCHEMA_ID = s.SCHEMA_ID
INNER JOIN sys.triggers tr ON tr.parent_id = t.OBJECT_ID
WHERE tr.is_disabled = 1