Incorrect SET options during UPDATE STATISTICS

Question

At the time of apply UPDATE STATISTICS on production Database (Sql server 2000)it give some error i.e.UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

Answer 1

0

At the top of your script, set them to the correct values and then set them back at the end of your script.

I assume you are doing this in a script?

SET QUOTED_IDENTIFIER ON            
SET ARITHABORT ON            
            
...Your Script...            
            
SET QUOTED_IDENTIFIER OFF            
SET ARITHABORT OFF

answered Oct 28 '09 at 08:30 AM

RickD
1.6k ● 1 ● 1 ● 4

(comments are locked)

Incorrect SET options during UPDATE STATISTICS

Follow this question

Related Questions