August 22, 2013 at 1:50 pm
Defrag job has been failing since ages for a server with the following error.
Executing the query "ALTER INDEX [IX_NetworkDetail_DestIPSort] ON [dbo]..." failed with the following error: "Cannot find the object "dbo.NetworkDetail_101_1529753" 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.
August 22, 2013 at 2:20 pm
That means that the object does not exist, or the account running the ALTER INDEX does not have enough permissions.
Try to find or validate that specific object inside the database. And run the ALTER INDEX with an account that has enough privileges.
August 22, 2013 at 2:39 pm
No issues with the account permissions though.
I will find out if the object exists
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply