When I run a maintenance plan to reorganize and rebuild tables indexes, it fails.
Below the last two rows that displays the fail:
Source: Reorganize Index
Executing query "ALTER INDEX [PK_xxTableName] O...".: 15% com...
The package execution fa...
The step failed.
What would be the cause?
Best Answer
Well, I have found the answer to this.
I removed the tick from "Compact Large Objects" option and just included the re-organize and re-build indexes tasks and it succeeded!!! Also I will log to text file for future failure details.