Friday, October 12, 2007 - Posts

My old mate sp_recompile

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/

The full version of this post can be found here.

As soon as i saw the error messages in the logs i thought to myself "Oh my, that did not happen in testing" (ok, maybe it was more colourful than that).

We were creating a clustered index on a tiny little table and the index went through fine. However, the application started to generate the message "Could not complete cursor operation because the table schema changed after the cursor was declared"..........

To read the complete version of this post go to here.