May 23, 2006 at 8:17 am
Has anyone come across this and know what it is? I am trying to run a query on a 2005 server that includes tables from that server as well as a table on a 2000 server. I am using linked servers in order to do use the 2000 server table. I also have different collation types between the servers, so I have to set that on the individual columns in the query. I've actually gotten this message back on a few different queries (they all use the linked server table though) using different tables, so I think it may be kind of generic. Following is my error message:
Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Msg 107, Level 16, State 2, Line 1
The column prefix 'Tbl1019' does not match with a table name or alias name used in the query.
The error has nothing to do with column alias names in my query, views, or tables as the message would have you believe. Thanks for your help!
May 23, 2006 at 1:23 pm
Without seeing the code, it's going to be almost impossible for us to help with this.
My guess would be what you say it can't be......somewhere in your script you have something like Tbl11019.col1 and you don't have a table with that name or a table alias that matches it.
-SQLBill
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply