Monday, March 26, 2012

Index Rebuild 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][ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
Regards,
Jamie
Hi
Can youb create your own script to rebuild indexes rather using DB MP?
SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON
DBCC <dbreindex>
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:5E8A8C25-0EDB-44C4-A261-0683B88EB6EB@.microsoft.com...
> 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 options
> have
> incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> --
> Regards,
> Jamie

No comments:

Post a Comment