"UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'

Question

SaveOrUpdate using nHibernate is getting the following error.

UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'

If I set arithabort on:

var command = session.Connection.CreateCommand();
command.CommandText = "Set Arithabort on";
command.ExecuteScalar();

Instead of getting the update failed, I get an nHibernate error because the number of rows effected is higher than expected.

How can I find out what is requiring the set arithabort on, or get nhibernate to accept the higher row effected count?

Is there a better way of telling nHibernate to use Arithabort on?

Answer 1

See http://groups.google.com/group/nhusers/browse%5Fthread/thread/afe690e85805871c?pli=1