SELECT 'ALTER TABLE ['+ SC.NAME+'].[' + PB.NAME + '] ENABLE TRIGGER ALL' FROM SYS.TRIGGERS TJOIN SYS.ALL_OBJECTS OB ON OB.OBJECT_ID = T.OBJECT_IDJOIN SYS.ALL_OBJECTS PB ON PB.OBJECT_ID = OB.PARENT_OBJECT_IDJOIN SYS.SCHEMAS SC ON SC.SCHEMA_ID = PB.SCHEMA_ID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sometimes, winning is not an issue but trying.
You can check my BLOG here
