Microsoft KB Archive/136966

{|
 * width="100%"|

FIX: Cursor Declaration In a Stored Procedure Causes Client AV

 * }

Q136966

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
Cursor declaration inside a stored procedure with aggregates and a variable can cause a client access violation (AV) during the execution of the stored procedure.

WORKAROUND
Perform an initial SELECT with the entire WHERE clause and INSERT into a temporary table, such as:

insert select

from where followed by DECLARE CURSOR from the temporary table:

"declare cursor for select col1 = sum(...) from"

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.

MORE INFORMATION
The replication scenario performs a DECLARE CURSOR by SELECTing an aggregate and has a variable referenced in the WHERE clause.

Additional query words: sql6 declare cursor av stproc

Keywords : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600