Microsoft KB Archive/172549

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

Article ID: 172549

Article Last Modified on 10/16/2003

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.