How to list table dependencies and triggers?

• sue-219486

  Grasshopper

  Points: 12

  More actions

  August 4, 2006 at 2:58 pm

  #169656

  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

   

• August 7, 2006 at 8:00 am

  This was removed by the editor as SPAM

• barsuk

  SSChampion

  Points: 12280

  More actions

  August 7, 2006 at 1:49 pm

  #653724

  to get a list of all triggers:

   

    select p.name,  

    t.name,  

    syscomments.text  

    FROM sysobjects t 

    INNER JOIN sysobjects p on p.id=  t.parent_obj  

    INNER JOIN syscomments on t.id=syscomments.id  

    WHERE t.xtype='TR'