We are still in SQL 2005 and I am wondering if there is EVER a possibility that data might change and the related trigger would not fire?? We have fields that are changing seemingly randomly. We have put triggers on the tables to catch the changes.
We have all the valid changes captured by the trigger, but the improper change is not captured and we have NO idea where the record change is coming from. Any thoughts??
Thanks in advance,
View Complete Post