trigger status

• ianfraser

  SSC Rookie

  Points: 38

  More actions

  April 9, 2002 at 9:15 am

  #78780

  Can anyone tell me if there is a way of getting back a full list of all the triggers in a database, and their status (enabled or disabled)?

  sp_help and sp_helptrigger don't quite give enough information. I see this is all stored in sysobjects, an dit appears to be the 'status' that identifies if a trigger is enabled or not.

  Thanks.

• ojn

  Say Hey Kid

  Points: 673

  More actions

  April 10, 2002 at 9:32 pm

  #427015

  select name,

  case objectproperty(id,'ExecIsTriggerDisabled')

  when 1 then 'Disabled'

  else 'Enabled' end [status]

  from sysobjects

  where xtype='tr'

  --

  -oj

  http://www.rac4sql.com