Knowledge Base

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

Article ID: 172549

Article Last Modified on 10/16/2003

Microsoft SQL Server 6.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition

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

Additional query words: tsql t-sql transql tran-sql

Keywords: kbbug kbfix kbprogramming kbusage KB172549