One of my SP does the update based on a full column value match, not only on primary key column. When I got a wired Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing’ problem on some updates, I think this must caused by that column match. Commented out one datetime column matching in where clause, problem disappear.
The ideal way to fix this problem should be, switch the hard match
where datatime_a = datetime_b
datediff(s, datatime_a, datetime_b) = 0
Similar to float type equality check.
But why this problem only happens to NHibernate?