Here's my query. I'd like to give the description field an alias to something like "uomdesc".
select * from openquery(linkedservername, 'select termcode, description as "uomdesc" from terms')
Here's the error I get:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL'...