Post reply

re: trigger not executing

  • September 25, 2003 at 10:41 am

    #82966

    Hello,

    I created a trigger on tblDelete. Aftering inserting a record in tblDelete it will delete the same record in the tblInventory.

    The problems are the trigger doesn't execute. The record(s) are inserted onto tblDelete but it doesn't remove in the tblInventory. When I go in the trigger properties under name drop box the trigger I created is not there. But when I tried to create a new trigger it saids the trigger object is already exist in the database.

    Please help!

  • September 25, 2003 at 2:26 pm

    #475881

    execute sp_helptrigger tblDelete.

    Check the owner of the trigger.

    Also check that the trigger is enabled, and you could also add some prints inside the trigger to check if it is running

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

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