FIX: Access Violation When Using UNIONs in Transact-SQL Cursors

ID: Q233190


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

BUG #: 54345 (SQLBUG_70)

SYMPTOMS

If a UNION appears as a subquery or derived table and the UNION contains parameters or local variables, the connection will get an access violation (AV). You will receive an error message similar to the following:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Connection Broken


WORKAROUND

To work around this problem, try either of the following:

  • Do not use a UNION as a derived table.

    -or-


  • If you do use a UNION, make sure it does not contain parameters or local variables.



STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: sub-query err

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug


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