Post reply

Has Trigger Fired?

  • May 12, 2002 at 11:53 am

    #78747

    Is there any way to know whether the trigger set on a table has been fired or not?

    Paras Shah

    Evision Technologies

    Mumbai, India


    Paras Shah
    Evision Technologies
    Mumbai, India

  • May 12, 2002 at 1:05 pm

    #428972

    Trigger should always fire unless it has been disabled. I guess if you need to see it you could add a line that logged an entry to a table.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • May 12, 2002 at 7:32 pm

    #428977

    Also to verify the trigger state this will help.

    SELECT OBJECT_NAME(parent_obj) tablename, [name] triggername, (CASE WHEN (STATUS & 2048) = 2048 THEN 'Disabled' ELSE 'Enabled' END) state FROM sysobjects WHERE xtype = 'TR'

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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