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