Index Fails over SET options

This came up before and it did not get fixed correctly on my end. Anyone?
--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'BIGSERVER' as OURCORP\BIGSERVER (trusted)
Starting maintenance plan 'DB Maintenance Plan1' on 11/22/2006 00:45:03
[1] Database DB1: Index Rebuild (leaving 10%% free space)...
Rebuilding indexes for table 'tAmexDemands'
Rebuilding indexes for table 'tAmexDemandsHistory'
Rebuilding indexes for table 'tAthensWarning'
Rebuilding indexes for table 'tATPOLines'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options
have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
--
Regards,
JamieHi
For indexes on Computed columns or views you need this setting to be ON,
DBCC USEROPTIONS will show you what the current settings are and you can use
the SET command to set them. If you want to change the system wide use
sp_configure to change the 'user options' value or sp_dboption to set the
specific values at database level.
John
"thejamie" wrote:

> This came up before and it did not get fixed correctly on my end. Anyone?
> --
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'BIGSERVER' as OURCORP\BIGSERVER (trusted)
> Starting maintenance plan 'DB Maintenance Plan1' on 11/22/2006 00:45:03
> [1] Database DB1: Index Rebuild (leaving 10%% free space)...
> Rebuilding indexes for table 'tAmexDemands'
> Rebuilding indexes for table 'tAmexDemandsHistory'
> Rebuilding indexes for table 'tAthensWarning'
> Rebuilding indexes for table 'tATPOLines'
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]DBCC failed because the following SET option
s have
> incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> --
> Regards,
> Jamie|||The database is inherited and no one seems to know where the computed column
s
exist. It is a rather large database (roughly 40 gig on the primary and 60
on the history filegroup). I'm running into problems searching for these
conditions. If I simply change options on the database, it will likely
present problems. I used a routine on the MSDN to rebuild indexes, but
there is no time to run it. TDay is filled up (11/23) with catch up
processes. Rebuilding indexes on this particular database is not an option
although some get rebuilt at night but not all. Also not all four processor
s
are used, only one. Apparently there is concern the production server is
about to crash. A backup plan is being implemented in this event, but there
are bottlenecks due to the physical size of the disks. The processor spike
s
into the 90 % area and averages in the 75% during peak production time.
While the machine manages during the day, it is failing to do the work at
night. Not sure what other options may be available.
--
Regards,
Jamie
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> For indexes on Computed columns or views you need this setting to be ON,
> DBCC USEROPTIONS will show you what the current settings are and you can u
se
> the SET command to set them. If you want to change the system wide use
> sp_configure to change the 'user options' value or sp_dboption to set the
> specific values at database level.
> John
>
> "thejamie" wrote:
>