Using Pseudo Columns with a Linked Server
If you use 4 part SQL when attempting to query a pseudo column, you will get an error. For example, in this query ROWID
is a pseudo column:
SELECT ROWID, ORDER_ID FROM MYLINKEDSERVER..SYSTEM.ORDERS Msg 207, Level 16, State 1, Line 4 Invalid column name 'ROWID'.
With 4 part SQL, you can only query physical columns in a linked server table, not pseudo columns.
To work around this, use the OPENQUERY
function instead. For example:
SELECT * FROM OPENQUERY(MYLINKEDSERVER,'SELECT ROWID, ORDER_ID FROM ORDERS')