July 29, 2002 at 1:37 pm
My Job to reindex the database fails, because DBCC Reindex needs to have proper settings for ARITHABORT and QUOTED_IDENTIFIER. However, since the DBCC Reindex is initiated via a Maintenance Plan, I can't seem to apply the correct settings. I tried placing them before the call to xp_sqlmaint in the Job step, but no luck. My Job continues to fail indicating that the settings are incorrect.
July 29, 2002 at 2:41 pm
Skip this in the maintenance plan and write a job to do this directly.
Steve Jones
July 29, 2002 at 3:31 pm
Normally the reindex works fine. What have you changed in your schema? Indexed view maybe?
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply