mmartin1 (12/30/2011)
HiSo from your latest post, I gather you have a synonym to a remote table? That is, it points to a table on another database in the same machine or another server? If I am not misunderstanding, I would create a local synonym for each one on the remote server. Then you just replicate the tables to keep things simple. Are your set of synonyms constantly changing?
Both, we have synonyms pointing to local as well as remote. There is a reason why we have synonyms going to remote, all insert/update/deletes go to publisher and reads go to subscriber.
I was wondering if there is any third party soln for this?