x

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

more ▼

asked Oct 28, 2009 at 01:41 AM in Default

user-289 gravatar image

user-289
21 1 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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
more ▼

answered Oct 28, 2009 at 08:30 AM

RickD gravatar image

RickD
1.7k 1 1 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x474

asked: Oct 28, 2009 at 01:41 AM

Seen: 1065 times

Last Updated: Oct 29, 2009 at 10:19 AM