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.

  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.

  3. rushmada New Member

    Thanks bambola.

  4. satya Moderator

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

    Satya SKJ

Share This Page