How to list table dependencies and triggers?

• sue-219486

  Grasshopper

  Points: 12

  More actions

  August 4, 2006 at 2:58 pm

  #91674

  I have about 80 tables in a SQL Server 2000 database.  I need to list all the triggers and dependencies set on each table.

  Is there a sample script or sample SQL statement that I can use to accomplish the above?

  Thanks

   

• Coriolan

  SSCommitted

  Points: 1931

  More actions

  August 4, 2006 at 4:23 pm

  #653444

  Link to a script to view all triggers

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1019