[font="Verdana"]

SELECT 'ALTER TABLE ['+ SC.NAME+'].[' + PB.NAME + '] ENABLE TRIGGER ALL'

FROM SYS.TRIGGERS T

JOIN SYS.ALL_OBJECTS OB ON OB.OBJECT_ID = T.OBJECT_ID

JOIN SYS.ALL_OBJECTS PB ON PB.OBJECT_ID = OB.PARENT_OBJECT_ID

JOIN SYS.SCHEMAS SC ON SC.SCHEMA_ID = PB.SCHEMA_ID

is this will be enough ? or even efficient?[/font]