September 26, 2011 at 9:20 pm
There is a maintenance plan, Update Statistics Task only, set for all the databases. This is failing from past two days with the error:
Executing the query "UPDATE STATISTICS [dbo].[XXXX]
WITH FULLSCAN
" failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Can anybody help me out why this happens. I am not getting any clue as to why the error is.
September 27, 2011 at 10:40 am
Have you tried running the command outside the maintenance plan? You might get a better error message.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply