Post reply

Get Triggers

  • December 20, 2006 at 9:46 pm

    #115841

    I have the query below to get all Triggers in a Database but how do I find out which Tables they belong to?

    I do not wish to use SP_HELPTRIGGER as I will have to use a cursor to loop through all tables and the output is ugly!

    Kindest Regards,

  • December 20, 2006 at 10:15 pm

    #679304

    Hi Mr. or Ms.500

    check this query and get the answer of your Question.

    Select object_name(parent_obj),* from sysobjects where xtype = 'tr' order by object_name(parent_obj)

  • December 20, 2006 at 10:41 pm

    #679308

    Cheers for that.

    Kindest Regards,

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

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