Hibernate version:
1.0.2

NHibernate and triggers
The following exception in application based on SQL Server 2005 and NHibernate :

[NHibernate.AdoNet.TooManyRowsAffectedException] {"Unexpected row count: 2; expected: 1"} NHibernate.AdoNet.TooManyRowsAffectedException

After a quick investigation the problem was obvious - the exception raises when a row from a table is updated and the row has fired a trigger which executes an update statement.

I have faced with this problem since early beta of NHibernate (0.8.4 as far as I can remember). Till now the only solution I have found is to use SET NOCOUNT to stop the message that shows the number of rows affected by a Transact-SQL statement from being returned as part of the results.

the solution found on the web doesn't really make me happy:
Just place SET NOCOUNT ON before the UPDATE statement inside the trigger and then after the UPDATE statement place SET NOCOUNT OFF. This will solve the problem.

Is there another way to solve this ??

Any help apreciated !
Thank you !
Stephan

Not sure there's another way to solve this but setting NO COUNT ON in triggers is considered a best practice. I always turn this on in every trigger.