>but that wont tell me what program changed it ,will it ? because we've a timer in our app which I used to monitor the table but can't figure out finding what program changing it.
The only other thing I can suggest is to log all the changes to the table and the user who is making this change. You need to find all places where your program may change the table.
If it's not broken, fix it until it is.
My Blog