Microsoft KB Archive/171945

= BUG: Access Violation If an Extended Static Cursor Runs a Stored Procedure Containing a GROUP BY =

Article ID: 171945

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q171945



BUG #: 17057 (NT: 65)



SYMPTOMS
You may receive a handled access violation (AV) if you execute a stored procedure with an extended static cursor more than once, and that stored procedure:


 * Joins two or more tables.

-and-
 * Contains a GROUP BY clause.



WORKAROUND
To work around this problem, do either of the following:


 * Use forward-only, keyset-driven, or dynamic cursors.

-OR-
 * Use WITH RECOMPILE on the stored procedure.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: ado asp tds activex active data objects pages

Keywords: kbbug kbusage kbsqlserv650bug KB171945

-

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

© Microsoft Corporation. All rights reserved.