When performing an "UPDATE" action through NHibernate on a SQL Server database which uses SQL Server Replication, the following error is returned:

"Unexpected row count: 2; expected: 1"

Obviously this makes sense since SQL Server replication adds "triggers" to the tables being replicated. I am aware of using the "SET NOCOUNT ON", but I am wondering if there is an NHibernate setting to not inspect the row count for UPDATE statements.

Any other solutions?

Thanks
Dennis

Not at the moment, but I made an entry in JIRA about this issue: http://jira.nhibernate.org/browse/NH-1353

I've just stumbled on a sql server book that said it is possible to globally "SET ROWCOUNT OFF" either for the target server or the user session. This is achieved by disabling the DONE_IN_PROC message. See: http://books.google.co.uk/books?id=fw9G ... &ct=result

I maybe wrong but it seems this would solve the issue with triggers but still allow the the toomanyrows excpetion to occur when under circumstances other than a trigger firing.

I have not tested this at all, but I thought it might help...

Christian