You are currently offline, waiting for your internet to reconnect

FIX: Access Violation Selecting Linked Table

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)
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
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:For more information, contact your primary support provider.

Article ID: 224996 - Last Review: 10/26/2013 04:48:00 - Revision: 4.0

Microsoft SQL Server 7.0 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix kbsqlserv700fix KB224996