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:
Additional query words: tsql t-sql transql tran-sql
Keywords: kbbug kbfix kbprogramming kbusage KB172549