QUESTION POSED ON: 29 November 2005
I am trying to set up a replication solution where the publisher resides on a different domain that I have no control over. The company that owns that domain will only give me read-only access to the database. I have given them database owner access to the distribution database for their server.
The idea is that they would set up the publication so the snapshots are FTPed to our distributor. The problem is that since I only have read-only access and the distributor is on our side, I cannot monitor or kick off the snapshot agent. Is there any way I can get around it without having to be system administrator or the database owner? Also, is there a way I can get SQL to compress large snapshots?
|
