SQL Server Performance

How to find a trigger is enabled / disabled.

Discussion in 'General DBA Questions' started by rushmada, Aug 18, 2003.

  1. rushmada New Member

    With the help of ALTER TABLE we can disable/Enable a trigger on a table.
    But how can we find that the trigger is disabled/Enabled.

    Rushendra
  2. bambola New Member

    select objectproperty(object_id('trigger_name'), 'ExecIsTriggerDisabled')
    There is a list of properties regarding triggers that you can find in BOL.

    Bambola.
  3. rushmada New Member

    Thanks bambola.

    Rushendra
  4. satya Moderator

    ObjectProperty function is one of the best invention in SQL 7 and fine tuned in SQL 2K with enhancements.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page