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

• Microsoft SQL Server version 6.5

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