FIX: Access Violation Selecting Linked Table

Article translations Article translations
Article ID: 224996 - View products that this article applies to.
This article was previously published under Q224996
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 54013 (SQLBUG_70)
Expand all | Collapse all

Symptoms

A select query using a linked server may generate an access violation if the following conditions are met:
  • The select is performed on a primary server, but references a table on a linked server.
  • The table on the linked server has a composite primary key.
  • The primary key contains a column whose name is a truncated version of another column name (for example, one column is named abc and another is named a).
  • In the primary key definition, the column with the full name precedes the column with the truncated name.
The query fails and a message similar to the following occurs:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Connection Broken

Status

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack SP1 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspx
For more information, contact your primary support provider.

Properties

Article ID: 224996 - Last Review: October 26, 2013 - Revision: 4.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbsqlserv700fix KB224996

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com