FIX: Transact-SQL Cursors Ignore NOCOUNT Query Option and Trace Flag 364 (172549)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
This article was previously published under Q172549
BUG #: 17091 (WINDOWS: 6.5)

SYMPTOMS

When executing a Transact-SQL cursor, the cursor returns empty result sets (DONE_IN_PROC messages) even when NOCOUNT or trace flag 3640 is enabled.

This means that if you do 100 fetch operations into local variables, the client must process 100 empty result sets.

CAUSE

The NOCOUNT and trace flag 3640 settings are ignored by cursor processing.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem was corrected in the latest Microsoft SQL Server 6.5 U.S. Service Pack. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K

MORE INFORMATION

For more information, see the following articles in the Microsoft Knowledge Base:

165951 : INF: Result Processing for SQL Server

151599 : HOW TO: Process Results in an Embedded SQL Application

Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbBug kbfix kbProgramming kbusage KB172549
©2003 Microsoft Corporation. All rights reserved.