Recently I faced issue in SQL server 2000. The Database maintenance plan was in place on weekly basis which were doing Update Statistics on the specified database. The Update Statistics job was failing everyday. When I checked the history of the job I found below error:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
The solution is to add a parameter in the Job:
-SupportComputedColumn: This parameter is the new feature that was introduced in SQL server 2000 Service pack4(SP4).
Add this parameter in the Job like below and excute the job, it will successfully execute.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID <GUID> -Rpt "Location of the output file" -WriteHistory -UpdOptiStats 10 -SupportComputedColumn'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
The solution is to add a parameter in the Job:
-SupportComputedColumn: This parameter is the new feature that was introduced in SQL server 2000 Service pack4(SP4).
Add this parameter in the Job like below and excute the job, it will successfully execute.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID <GUID> -Rpt "Location of the output file" -WriteHistory -UpdOptiStats 10 -SupportComputedColumn'
No comments:
Post a Comment