:::: MENU ::::

Error generated due to schema binded view

  • Oct 16 / 2008
  • 0
dbDigger, Indexes, Troubleshooting

Error generated due to schema binded view

Our web application started to generate error messages while inserting/updating through specified form. Another DBA just used index Tuning Wizard and created some indexes there. The Error statement showed in browser was.

INSERT failed because the following SET options have incorrect settings: ‘ARITHABORT’

Description: An unhandled exception occurred during the execution of current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System .Data.sqlclient.SqlException: INSERT failed because the following SET options have incorrect settings: ‘ARITHABORT’

Source Error:
An unhandled exception was generated during the execution of current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:
..
..

..

So as we analyzed the database. A new view was found that was created by index tuning wizard. As the specified view was deleted, application started working properly without any error.

Consult us to explore the Databases. Contact us