Gail,

I can't do that (change the code). That could materially change how the trigger works. While in this case it is a single insert (via a values ()), I'm not sure about the others. I do suspect this is not the problem (@@rowcount) but thought maybe someone had run into this before.

As for SQL 6.0. They system now runs up to SQL 2012 but the vendor has not upgrade their database design or much of their code to take into account new standards and features. I have found this to be very common with the accounting packages I have worked with (that they don't upgrade working code).

John