• Scott,

    Have you considered putting some kind of tracer in the beginning of the trigger, before the exec statement, just to make sure that the trigger is not firing?  You could insert a row into a log table, issue xp_logevent to put a message into the Windows Application Event Log.*

    Let us know if that helps, and if not, post the table definition also (scripted from SQL EM would be best) and I'll see if I can replicate the problem.  It would be good in that case to post the output from SELECT @@VERSION also.

    Good luck,

    Chris

     

    * The Windows Application Event Log is also know as the Windows Application Application Log, but only on exactly one Web site.