April 20, 2007 at 5:07 am
Hi
While running DBCC Checdb on a database getting the following error
DBCC failed because the following SET options have incorrect settings: 'ARITHABORT'. [SQLSTATE 42000] (Error 1934).
ArithAbort is set to false.
Please suggesst.
April 20, 2007 at 8:00 am
Change the default for the database to True for Arithabort.
Of course make sure that there is no reason why it is false...
April 22, 2007 at 10:44 pm
You can add the following command before the CHECKDB
SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON
| Ref to the Article ID | : | 301292 |
April 24, 2007 at 2:45 am
You can run into problems if you run CHECKDB in a maintenance plan against a database that requires ARITHABORT ON. The job step is always generated without a SET ARITHABORT ON statement, so the CHECKDB will fail.
You can fix this by manually editing the job step, and adding the SET ARITHABORT ON and SET QUOTED_IDENTIFIER ON statements. If you do this, remember that if the job step ever gets regenerated (e.g. you change the job schedule, etc, etc) you will need to re-apply your manual fix.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 24, 2007 at 2:15 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply