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,
JamieHi
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment