How to list all triggers on all databases ?

• mpescarmona

  SSC Enthusiast

  Points: 127

  More actions

  June 9, 2008 at 11:00 am

  #124144

  I need know how to list all the triggers from all the databases hosted in my server. All the sp that i look run only over the current db. I use sql server 2000.

  Thanks in advance

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  June 9, 2008 at 11:12 am

  #826215

  mpescarmona (6/9/2008)

  ---

  I use sql server 2000.

  Then you should post this in a SQL 2000 forum.

  [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]

• Luiz-458831

  SSCommitted

  Points: 1904

  More actions

  June 9, 2008 at 11:22 am

  #826221

  You can use:

  EXEC sp_Msforeachdb "USE ? SELECT * FROM sysobjects where type='TR'"

  in SQL2005. I believe it works also in SQL2000.

  Luiz.