Error: CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'. : LiveDDM

Error: CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'. Print

Modified on: Mon, Dec 13, 2021 at 1:47 PM

Problem

When launching the LiveDDM Management Client portal, you receive a migration error and observe the following error in the Even Viewer:

CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'.

Issue

The LiveDDM database must be set to a compatibility level of 100 or higher.

Resolution

User can continue to use LiveDDM while this resolution is applied.

Set the LiveDDM database compatibility level to SQL Server 2008 (100) or better.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk