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!