April 25, 2006 at 2:27 pm
I created a maintanace plan for one database for optimization check and Integrity check which was run successfully last week. Later I added some more databses in the maintanace plan ,which failed.
when I saw the "Database mainatance plan history" it was showing success for some databases and failure for some databses. Error is as follows:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
April 28, 2006 at 8:00 am
This was removed by the editor as SPAM
April 28, 2006 at 10:46 am
Can I set options in job step like
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
Does this effect the database settings or server? As this is in the production server.
May 24, 2006 at 6:46 am
This is a fix for when a maintenance plan errors out rebuilding the indexes on a table that has a computed column. Just add -SupportComputedColumn to the command line. This only works on SQL Server 2000 SP4.
Example:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID ADE4EC09-004C-4AF4-A93D-6E4F53499920 -Rpt "d:\sql2000\MSSQL\LOG\DB Maintenance Plan10.txt" -DelTxtRpt 1WEEKS -WriteHistory -RebldIdx 30 -SupportComputedColumn'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply