IF OBJECT_ID ('myAfterTrigger', 'TR') IS NOT NULL DROP TRIGGER myAfterTrigger go CREATE TRIGGER myAfterTrigger ON myTable AFTER INSERT, UPDATE, DELETE AS SELECT 'AFTER: Trigger Fired on' as TriggerName, GETDATE() as Date_Time