• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

SqlServer Exception

When i am trying to run the SP from asp.net, i am getting the below error.

INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Can i please know the reason for the issue.....................
0
Praveen_Bobbili
Asked:
Praveen_Bobbili
1 Solution
 
yeelokhkCommented:
This problem is occurred when you attempts to insert a row into a table that is referenced in an indexed view.

Here is the official solution to your problem:
http://support.microsoft.com/kb/305333
0
 
brutaldevCommented:
This is normally an issue with newer API's calling into older databases. An easy way around this is to configure the compatibility of the SQL Server to at least 2005:
ALTER DATABASE YourDatabaseName SET COMPATIBILITY_LEVEL = 90

Open in new window

You can also try set it on in code if you can't change the server, look here: http://support.microsoft.com/kb/305333
0
 
Praveen_BobbiliAuthor Commented:
If we change the compatibility level it will effect the remaining procedures. They may not work properly. We can use this, it works for me.
ALTER DATABASE YourDatabaseName SET ARITHABORT ON
0
 
Amandeep Singh BhullarCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now