linked server function not returning suggestions

austrianfoodispuke

I have

or rather a user a given me some lovely code

which is using lots of table functions on a linked server


select x.<nothing happens> from db.dbo.tablefunction() x


Both dbs are sql 2005 and i'm running 2008 mgmt studio with prompt 3.9

Refresh cache has no effect

Also when I tried expanding out his 'select * from' (stop laughing) the aliases were completely ignored

How can I fix this?



I did try searching the forums but after waiting more than minute (twice) with no page coming back, I gave up and posted this

austrianfoodispuke

Table functions are not supported on linked servers, so I have been informed