Thanks Mike, SET NOCOUNT solved it. For future reference for anyone else using an UPDATE or DELETE trigger for audit trails, this toy trigger now passes the test, inserting a single record to ttable, and raising the exception on the second save:  Code:ALTER TRIGGER [dbo].[tu_clients] ON [dbo].[clients] FOR UPDATE NOT FOR ...