Post reply

Oh where is my trigger

  • October 5, 2005 at 4:27 pm

    #91406

    After making a trigger with a template, where can i locate the trigger for manipulation or deletion?

     

    Erik..

    Dam again!

  • October 5, 2005 at 4:35 pm

    #595299

    --to get a list of triggers in the database

    SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'TR'

    GO

    --to look at the trigger body

    SP_HELPTEXT Trigger_Name

    GO

    --to drop the trigger

    drop trigger trigger_name

    and to modify, just modify the definition and re-create it. 

    If you are asking about where to look for it in Enterprise Manager, then open up the database that you are interested in, select the table, right click and All Tasks/Manage Triggers and select your trigger for manipulation/deletion.

  • October 5, 2005 at 4:39 pm

    #595301

    Ok i found it!

     

    Thank you very much for the reply.

     

    Erik....

    Dam again!

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

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