I am trying to create a Synonym of a Table-valued function residing on a linked server. I've tried everything it seems and it just won't work - I keep getting this error:
The OLE DB provider "SQLNCLI" for linked server "Server01" does not contain the table ""MyTable"."dbo"."GetOrder"". The table either does not exist or the current user does not have permissions on that table.
The function takes a single int value as input, and does nothing fancy but join a couple of tables.
explenation I have found for this error, is that the user I'm trying with doesn't have sufficient credentials, but now I have tried to create the linked server with the "sa" user, logging in and executing the SQL with the "sa" user and generally just granted db_owner rights all around, and NOTHING works!
Does anybody have any insight to this - is it just impossible to create synonyms of Functions over linked server?
Btw. executing sproc's etc. over the linked server (without synonyms) is working fine, but we'd really like to utilize this new feature in our setup.