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

ID: Q171945


The information in this article applies to:
  • Microsoft SQL Server version 6.5

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 : kbusage SSrvTran_SQL kbbug6.50
Version : 6.5
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: April 20, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.