FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used
Source: Knowledge Base
Product: Microsoft SQL Server 2005 Standard
Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition
Notification Contents: New and All Modifications
FIX: Error messages when you run a query against a linked server that you
create in SQL Server 2005: "Statement(s) could not be prepared" and "The column
prefix '<column_prefix_name>' does not match with a table name or alias
name used in the query"
http://support.microsoft.com/kb/936223/en-US