(SQL Server 2008 SP1)
Hi I have a stored procedure that runs frequentely (uses a cursor), that SP never have errors on execution, but when runs at the same time with a rebuild index task (Database maintenance task on sundays), the stored procedure show the following
"Could not complete cursor operation because the table schema changed after the cursor was declared"
My question: Is there any way to avoid this problem running the two task at the same time? Is this a bug of the SQL Server 2008?JAC
View Complete Post