FIX: Access Violation Selecting Linked Table (224996)

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.