I am using the default SQL Server Maintenance task to reorganize index only which was running until I got the below error.
Executing the query "ALTER INDEX [PK_abc] ON " failed with the
following error: "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.
I have checked DBCC check db and no errors reported. Can this be due to low Transaction Log space as reorg don't consume space specially on data disk or I need to look at other direction. Any guidance would be greatly appreciated.
Best Answer
We can't say why, since you posted the SSIS error message. A maintenance plan is an SSIS package. SQL Server returned an error message to SSIS, and SSIS show you something else. You need to hunt down the SQL Server error message. Check the maintenance plan report file, assuming you have such. And the maintenance plan history table as well.