To list all trigger

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  June 14, 2008 at 1:08 am

  #183440

  Hi,

  Could any one tell me how I can list all trigger in a database?

  With regards

  Sunil

• navaneethCBE

  Newbie

  Points: 9

  More actions

  June 14, 2008 at 4:14 am

  #828878

  select * from sysobjects WHERE XTYPE ='TR'

• bahnsteig8

  Old Hand

  Points: 362

  More actions

  June 14, 2008 at 6:05 am

  #828879

  to see also the concerned table:

  SELECT ta.name AS

  , tr.name AS [trigger name]

  FROM dbo.sysobjects tr

  INNER JOIN dbo.sysobjects ta ON tr.parent_obj = ta.id

  WHERE tr.xtype = 'TR'

  ORDER BY 1, 2

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  June 14, 2008 at 10:43 pm

  #828955

  Select * from sys.triggers

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]