I have a MS Sql Server db with indexed, computed columns. I'm trying
to insert a record utilizing session.SaveOrUpdateCopy(entity); but the
following error is thrown:

NHibernate.HibernateException: An exception occurred when executing
batch queries ---> System.Data.SqlClient.SqlException: UPDATE failed
because the following SET options have incorrect settings:
'ARITHABORT'.

Is there a way to configure NH to output the sql
SET ARITHABORT ON
<actual nh sql>
SET ARITHABORT OFF

ideally I only want to configure this for the 2 specific tables that
have computed columns, but if I need to apply it to all tables (or if
this a simple 1 line config for all tables) I can use that as well.

thank you in advance

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to