Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-04 : 11:21:40
|
| DV writes "The optimization part of my maintenance plan fails on rebuilding indexes for one particular table with the error: "[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'."SQL Server 2000, on Windows 2000 Server, SP2.I'd prefer to leave this function as part of a maintenance plan, so within that scope, what do I do?Thanks for the help." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-04 : 14:55:19
|
| Sounds like you have an index on a computed column. This trips up sqlmaint because SQL agent doesn't set QUOTED_IDENTIFIER or ARITHABORT to ON, both of which are required for operations against indexed computed columns or indexed views. Remove the integrity checks,reorganisation from the maintenance plan and put them in a sql job step [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q301292[/url]HTHJasper Smith |
 |
|
|
|
|
|
Error 1934, maintenance plan - optimization of database