Find hidden triggers in database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anuragshrivastava64
    New Member
    • Jan 2007
    • 66

    Find hidden triggers in database

    I am new to SQL Server.
    I have got a project where lot of stored procedures ,UDF's and triggers are used.
    The problem is I am finding all the functions and procedures but not been able to find any of the TRIGGERS.
    Can anyone plz tell me where can I find the triggers.

    I used the query (Select * from Sysobjects) and it shows 52 triggers
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Code:
    select * from sysobjects where xtype = 'TR'
    then you go

    Code:
    sp_helptext <trigger_name>
    -- CK

    Comment

    Working...