what are some of the cases that will cause a SQL Server 2005 cursor to deallocate prematurely?
+2
A:
One thing comes to mind: a sufficiently severe (20+) error being raised on the connection will blow away the entire connection -- cursors, local temporary tables and all.
Jeffrey Hantin
2009-09-10 21:50:51