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


The information in this article applies to:

  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbSQLServ650bug kbusage KB171945 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.