question

user-289 avatar image
user-289 asked

Incorrect SET options during UPDATE STATISTICS

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'.

sql-server-2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
RickD avatar image
RickD answered

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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.