Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: trigger not executing

    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!

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    I had this problem once. I think (it was quite some time ago) I had to go into sysobjects and delete the trigger there, then re-add it.
    -bpd

  3. #3
    Join Date
    May 2002
    Posts
    395

    trigger script

    Originally posted by bpdWork
    I had this problem once. I think (it was quite some time ago) I had to go into sysobjects and delete the trigger there, then re-add it.
    I'll look into it.
    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •