While testing one of the web applications I built, I started getting this error on one of the stored procedures.The application was using 3 databases to manage data and the users would make changes to a local database and after reviewing the changes would move the changes to the staging and then an admin would move all the changes by the users to the final database.So,In my original test application setup,I had 3 databases i.e. local,staging,final on the same server and the stored procedure to update the staging from local database was working.
However when we moved the test database to a different server and modified the stored procedure to point to the new test server we received this error.
UPDATE 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.
The fix was to reconfigure the user options on the database that was moved to the new server
sp_configure 'user options', 64
reconfigure
reconfigure
More about the user options here http://technet.microsoft.com/en-us/library/ms190763.aspx
No comments:
Post a Comment