October 24, 2010 at 2:47 pm
I am getting the following error on Rebuild Index Maintenance Task.
"Executing the query "ALTER INDEX [PK_cartrige] ON [dbo..." 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."
Where can i find more details on troubleshooting this error and find more details on the error. It seems to be a persistant problem since sql server 2005.
Details:
1.-Maintenance Plan has been working well for months.
2.-Std Edition Sql Server 2008
3.-Db Integrity check successfull
4.-sort result in tempdb is off
5.-keep index online while reindexing is off
6.-local server connection works for all other jobs prior to the task
October 24, 2010 at 3:41 pm
That error can mean just about anything.
If you rebuild manually, does it work?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply