Monthly Archives: July 2009

Pretty trivial, really: SELECT ‘ALTER TABLE ‘ + OBJECT_NAME(PARENT_ID) + ‘ ENABLE TRIGGER ‘ + [NAME] FROM sys.triggers     …add a where clause if needed.  Paste the output back into the query window and modify as needed.  You can also slap … Continue reading →