Post reply

Finding triggers and stored procedures from systables

  • June 29, 2004 at 8:44 am

    #86020

    I need more help navigating the system tables.  Can anyone tell me how to find the triggers and the trigger code attached to a table?  I also need to find the user stored procedures and code in the db.

    TIA

  • June 29, 2004 at 1:08 pm

    #512526

    You may want to check out  sp_helptext on books online

     

    Michael

  • June 30, 2004 at 12:12 am

    #512570

    For Trigger:

    SELECT OBJECT_NAME(a.[ID]) TriggerName, b.[Text] TriggerCode FROM SysObjects a INNER JOIN SysComments b ON a.[ID] = b.[ID]

    WHERE a.Type = 'TR'

    For Procedure:

    replace the Type with 'P'

    You can also find the Procedure and Function details from the information_schema.routines view

     


    bm21

  • June 30, 2004 at 8:01 am

    #512669

    That is great. 

    Thanks very much.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply