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

• Microsoft SQL Server versions 6.0, 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:

Q165951 : INF: Result Processing for SQL Server

Q151599 : INF: How to Process Results in an ESQL Application

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

Keywords          : kbprg kbusage SSrvGen SSrvProg SSrvTran_SQL kbbug6.50 kbfix6.50.sp4 kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 19, 1999