linked server function not returning suggestions

austrianfoodispukeaustrianfoodispuke Posts: 100
edited August 27, 2008 6:05AM in SQL Prompt Previous Versions
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


Sign In or Register to comment.