Microsoft KB Archive/235407

{|
 * width="100%"|

BUG: Connection Hangs When Using Asynchronous Cursor to Insert Data Into Temp Table

 * }

Q235407

-

The information in this article applies to:


 * Microsoft SQL Server version 7.0

-

BUG #: 55916 (SQLBUG_70)

SYMPTOMS
Using an asynchronous cursor to insert data into a temporary table may cause the client connection to hang with the following symptoms:


 * SP_WHO shows the Server Process ID (SPID) with a status of sleeping.
 * When querying the master..sysprocesses table the waittype for this SPID will be 0x020C and the lastwaittype will be CURSOR.
 * The SPID does not respond to the kill command.

This problem only affects the current connection. All other server activity is unaffected and proceeds normally.

WORKAROUND
To workaround this problem, choose any one of the three following options:


 * Use a dynamic, forward only, or fast forward only cursor. Only keyset (scroll) and static (insensitive) cursors are generated synchronously.
 * Disable asynchronous cursor generation by setting the "cursor threshold" option in sp_configure to -1.
 * Insert the data into a permanent table rather than a temporary table.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words:

Keywords : kbSQLServ700bug

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ700