April 21, 2009 at 4:13 am
Hello, hope somebody can help me out. I am running SQL 2000 SP4
I have a maintenance plan failing and I know that it is because I have a computed column in a database, I did find this fix...
http://support.microsoft.com/kb/902388 (although to be honest, my error is the same but does not mention Arithabort). It is a default instance.
I have installed SP4 as the article suggests, but I am not sure how to apply the work around, I bring up the properties of the job, but do I use the drop down box to specify the database I want to apply it to? I do not seem to be able to find the 2 jobs that contain 'RebldIdx' and 'CkDB' which are in the article.
The actual error I am getting is as follows...
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
Could somebody point me in the right direction? It has been suggested that I create separate maintenance plan jobs for the database that is causing the maintenance job/s to fail but I would rather implement this workaround if possible.
Thank you for any help.
Regards,
D.
Edited: 4/15/2009 4:08 PM by Duran
April 21, 2009 at 4:33 am
Please run the appropriate command from query analyser that should do it.
EXECUTE master.dbo.xp_sqlmaint N'-S ServerName\InstanceName -PlanID -WriteHistory -CkDB -SupportComputedColumn'
-Sat
Cheer Satish 🙂
April 21, 2009 at 5:43 am
Hello, firstly thank you for your repsonse but I am convinced that this is not run in query analyzer as the article clearly mentions that...
'To work around this problem, add the –S ServerName\InstanceName parameter and the -SupportComputedColumn parameter to the command that is included in the first step of the following jobs.'
So I am still sure that I am supposed to alter the t-sql code within the job itself, I also need to know whether having got to that stage, whether I need to select the database with the computed column or leave it on 'master'.
Regards,
D.
April 22, 2009 at 4:43 am
Hi Duran,
Though the article does not mention about running it on SQL ANALYZER it is supported and could run it there.
If you want to add it to job menu in EM follow the steps below
Open Enterprise Manager SQL 2000 --> Managment --> Jobs --> On right side look fo Integrity check Job --> Right Click on the job got properties --> goto "Steps" tab --> select step1 and click EDIT you can add it here and test.
Hope this helps.
-Sat
Cheer Satish 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply