I am using SQL Servers Publish and Subscribe approach to copy content from my server to another. However, as the subscribing server is not on the same network, I'm having to publish the content to the server's hard disk and then have an FTP job copy it to the other location and then reimport it.

I'm told that the Subscription will expire on a regular basis as there has been no connection from the subscribing server within a given time.

Is there :

a. a better way to do this ?
b. a way to set the timeout to NEVER ?

__________________
All the best

Greg
------------------
Greg Griffiths
Web & Livelink Developer
http://www.greggriffiths.org

Hi,

To ensure subscriptions never expire, in Enterprise Manager display the properties for the Publication, select the General tab, and check the 'Subscriptions never expire' radio button at the bottom of the dialog.

If you need to do this in TSQL, the @retention parameter of sp_addpublication or sp_addmergepublication should be set to 0.