First things first: I'm using MS SQL Server 2008 with a database at compatibility level 80, and connecting to it with .Net's
For performance reasons I've created an indexed view. As a result, updates to tables referenced in the view need to be done with
ARITHABORT ON. However, the profiler shows that SqlClient is connecting with
ARITHABORT OFF, so updates to those tables are failing.
Is there a central configuration setting to make SqlClient use
ARITHABORT ON? The best I've been able to find is to manually execute that each time a connection is opened, but updating the existing code base to do this would be a fairly large task so I'm keen to find a better way.