February 22, 2010 at 11:45 am
I've got a maintenance plan with an UPDATE STATISTICS task which is failing since about a month ago. No changes have been made by us on the database, and the product hasn't been updated by the vendor. The error it returns is below - it looks as though the task tries to UPDATE STATISTICS on a table that no longer exists - and I am not sure how to correct the problem, since it is a generic maintenance plan task. I assume it is pulling the list of tables from some out-of-date source? If so, how can I correct it so the task will complete successfully? Kind of a head-scratcher.
Thanks!
---
"Executing the query "UPDATE STATISTICS [dbo].[XXXX]
WITH FULLSCAN,COLUMNS
" failed with the following error: "Table 'XXXX' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
----
February 22, 2010 at 5:11 pm
How is the task configured?
Does the Task Config. screen have a 'View TSQL' button? I can't remember if Sql 2005 has this. This should show you exactly what TSQL it generates.
February 22, 2010 at 9:57 pm
Have you tried to edit the job from SSMS? assuming it is a SQL standard maintenance plan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply