SHARE
TWEET

Untitled

a guest Aug 25th, 2019 55 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top