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

• Microsoft SQL Server version 7.0

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: June 8, 1999