March 8, 2010 at 1:30 pm
Executing the query "ALTER INDEX [PK__EventSta__95632343015DD3D9] ON [E..." failed with the following error: "Cannot find index
'PK__EventSta__95632343015DD3D9'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
Ran Command:
SELECT COUNT (*) from sys.objects where name='PK__EventSta__95632343015DD3D9'
which returns a result of 0.
Looking for direction on how to either add or remove the PK_EventSta_ column/row from the index operation to get the maintenance schedule back on track.
March 8, 2010 at 2:23 pm
Looks like you have a process that is running at the same time as this step in your maintenance plan that is dropping that table.
When the maintenance plan starts, it builds a list of objects that are going to be reindexed. Sometime after that has happened, and before the process gets to that index - the index is removed or the table dropped.
Find the process doing that and you should be able to get past that problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply