Trigger status???

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  May 24, 2005 at 3:30 am

  #102545

  Hi,

  Anyone know how I can find out whether a trigger is enabled/disabled or not without using DMO?

  I would have assumed that sp_helptrigger would give the answer...but no.

  Thanks in advance!

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 24, 2005 at 3:53 am

  #560704

  SELECT OBJECTPROPERTY(OBJECT_ID('tigger_name'), 'ExecIsTriggerDisabled')

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  May 24, 2005 at 3:59 am

  #560705

  Brill. Thanks Chris.

  I might ask MS if they can include this in sp_helptrigger

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson