-- Mostra as definições da trigger
SELECT definition
  FROM sys.sql_modules
 WHERE object_id = OBJECT_ID('TRG_DLT_EVTFILA');

-- ALTER TABLE table_name (enable/disable) TRIGGER triggers_name
 ALTER TABLE evtfila
ENABLE TRIGGER trg_dlt_evtfila

-- Verifica quais triggers estão desativadas
SELECT *
  FROM sys.triggers
 WHERE is_disabled = 1