INSERT failed because the following SET options...

Problem

You get this error when adding or updating a data record from a web page in your application:

Unable to create record. INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.

This is a Microsoft SQL Server error caused by creating an Indexed View.

Solution

When you have an Indexed View in your database, you must execute the SQL command 'SET ARITHABORT ON' each time you connect to Microsoft SQL Server before executing any other SQL command. This Microsoft knowledge base explains in detail:

http://support.microsoft.com/default.aspx?kbid=305333

You can eliminate this error by deleting the indexes from your database views.