Microsoft KB Archive/148268

{|
 * width="100%"|

BUG: Variable in Cursor Declaration Can Cause Client AV

 * }

Q148268

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 13038 (6.00)

SYMPTOMS
Assigning values of table columns to variables inside a cursor declaration can cause a client access violation (AV). Ideally, this should give a syntax error because variable assignment is not allowed in a cursor declaration.

WORKAROUND
Make sure that the cursor declaration is according to syntax of cursor declaration statement.

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

Additional query words: sql6 av client

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600