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
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