Guest User

Untitled

a guest
Aug 25th, 2019
57
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Mostra as definições da trigger
  2. SELECT definition
  3. FROM sys.sql_modules
  4. WHERE object_id = OBJECT_ID('TRG_DLT_EVTFILA');
  5.  
  6. -- ALTER TABLE table_name (enable/disable) TRIGGER triggers_name
  7. ALTER TABLE evtfila
  8. ENABLE TRIGGER trg_dlt_evtfila
  9.  
  10. -- Verifica quais triggers estão desativadas
  11. SELECT *
  12. FROM sys.triggers
  13. WHERE is_disabled = 1
RAW Paste Data