sql2008- reorganize index failed
Posted on 2012-08-27
DB Maintenance plan failed with following error message:
Executing the query "ALTER INDEX [M_MR0A1_F_IX1_1] ON [dbo].[M_MR0A1] REORGANIZE WITH ( LOB_COMPACTION = ON )
" failed with the following error: "Cannot find the object "dbo.M_MR0A1" because it does not exist or you do not have permissions.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
But when I run this manually it succeed, what is wrong with maintenance plan then ?