Insert trigger not function

• AhTu_SQL2k+

  Ten Centuries

  Points: 1012

  More actions

  December 10, 2008 at 9:10 pm

  #125747

  Hi there,

  Just lately reported by my staff that an insert trigger in a table suddenly stop functioning after running for almost a year.

  I troubleshoot it by open table and inserting a record, it works! However, when i insert record thru a program, the table trigger failed its function (but record was inserted)!

  So, I decided to drop and generate the trigger and everything is back to normal.

  I know i had solved this trigger issue now but i am worring about my other 30 or more triggers in the db will have the same problem in the future!

  Can anyone tell me how to prevent this to happen again?

  Thanks in advance.

  Together, we can make wonders!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  December 10, 2008 at 9:26 pm

  #910811

  Moved to T-SQL

  You should trace and see how the application is inserting data. There might be something else.

  Are there also instead of triggers on the table?

  You need to provide some code for us to see.