December 2, 2013 at 11:28 am
Rebuild index as well as index defrag jobs are failing with the following error message. How do I fix them?
Executing the query "ALTER INDEX [IX_TentFlowDetail_Sort] ON [dbo]..." failed with the following error: "Cannot find the object "dbo.TentFlowDetail_33_3439843" 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.
December 3, 2013 at 3:25 am
Seems reasonably clear. This error: Cannot find the object "dbo.TentFlowDetail_33_3439843"
It can't find the object to rebuild it. You are either passing in the wrong object name, or the wrong schema name, or something else that is making the name incorrect.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2013 at 7:49 am
But I have configured the jobs through maintenance plans.
How do I make this change?
December 3, 2013 at 7:52 am
Not seeing the maintenance plan or your structure, I'm not sure. But, something is wrong. That name is not there. It's the wrong schema, it's been renamed while you were running, something. That error is pretty specific.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply