FIX: Nested Cursors Can Cause a Handled Access Violation

• Microsoft SQL Server version 6.5

SYMPTOMS

A nested cursor fetch on basic select type cursors can cause a handled access violation, as well as the inability to locate locally defined variables or the cursor. The SQL Server error log will contain a Language Exec error, followed by a stack trace. The following errors, as well as a client disconnect, are reported on the client:

16921 Cursorfetch: Must declare variable '%s'.

16916 A cursor with the name '%s' does not exist.

WORKAROUND

Do not use cursors in a nested fashion where the inner cursor relies on the results of the outer cursor.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: AV

Keywords          : kbnetwork SSrvErr_Log kbbug6.50 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 3, 1999