FIX: Access Violation Selecting Linked Table

• Microsoft SQL Server version 7.0

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.

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 version 7.0. This problem has been corrected in U.S. Service Pack SP1 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: exception

Keywords          : kbbug7.00 kbSQLServ700 kbSQLServ700bug kbSQLServ700fix 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: June 8, 1999