Error 1934 on index rebuild

[timscronin]

When my rebuild indexes I am getting the following error message in the log file which the maintenance job does. It shows the normal indexes rebuilt for the tables but then errors out with this

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

I can't find anything on the MS site. Has anyone seen this before?

 

[JayKusch]

Thursday August 22, 2002 3:41 AM



The error message is more likely to occur if the CHECKDB or CHECKTABLE is being scheduled from a SQL Server Agent job or from an Integrity Check in a Database Maintenance Plan.

To resolve this schedule a DBCC CHECKTABLE or CHECKDB integrity check on the database, you must create a SQL Server Agent Job and in the Transact-SQL command you must add the needed SET OPTIONS as in the following example:

SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON
DBCC CHECKTABLE(mytable)
go


Thanks

J. Kusch

 

[timscronin]

I tried inserting the statement before the step to run the db maint plan. What I have discovered is that this is a large table and if I go to a recent copy where there were a few less fields it works fine. If I add the 2 new fields it chokes. I ran profler and can copy the dbcc statement into qa and it works fine.

 

[tlbroadbent]

Does the table have computed columns? If so, does an index exist on the computed column(s)? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[timscronin]

Yes it does, but no the index is not on that column. MY guess it is an undocumented limit that I have reached. I would like MS to verify this. THe fact that all I have to do is add a few columns and the error appears is what is based on