May 19, 2008 at 8:12 am
I get this error: Could not complete cursor operation because the table schema changed after the cursor was declared. - 42000
May 19, 2008 at 8:39 am
Is this in the log for the maintenance plan? Which job is this for?
May 21, 2008 at 7:59 am
Hi Thank you for responding. It is not in the log but in an e-mail sent to me every two minutes. I'm not sure what caused this. I did a VMware copy of the server that has the SQL database then created a new maintenance plan. Any ideas would be appreciated. thank you.
May 21, 2008 at 8:33 am
Very strange. I'm not sure what happened here. I know the maintenance plan opens a cursor in some tasks to loop through databases, but I'm not sure why you'd get this error.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply