Microsoft KB Archive/224996

= FIX: Access Violation Selecting Linked Table =

Article ID: 224996

Article Last Modified on 7/19/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q224996



BUG #: 54013 (SQLBUG_70)



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.

Additional query words: exception

Keywords: kbbug kbfix kbsqlserv700fix KB224996

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.