We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

sql server alter database question

Medium Priority
353 Views
Last Modified: 2012-05-11
I am trying to delete a row in my db and I get this message:

DELETE 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.

I have done a little research and it appears that I need to run the following command:

ALTER DATABASE MyReportingDB SET ARITHABORT ON

Is that so and, if so, why?

Thanks~
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Bob SchneiderCo-Owner

Author

Commented:
I am trying to delete a single record in my sql server 2008 db.  I tried this in the "New Query" window using a "delete from mydb where ...".  It is tied to other records in other tables via a PK-FK relationship with the PK being in the record I am trying to delete.
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Bob SchneiderCo-Owner

Author

Commented:
the PK table, the one that houses the record I am deleting, is used in an index.  
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Bob SchneiderCo-Owner

Author

Commented:
I raised the compatibility level to 100.  We will see what happens.  Thanks!!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.