Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 18th, 2004, 05:55 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default SQL Server Publish & Subscribe issue

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 Griffiths
Web & Livelink Developer
Old August 18th, 2004, 02:18 AM
Authorized User
Join Date: Aug 2004
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts


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.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report & VB6 & SQL Server wlho VB How-To 2 June 5th, 2013 01:58 AM
Sql server custom code issue aranjan BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 February 13th, 2008 08:24 PM
SQL Server 2000 connectivity issue avixorld ASP.NET 2.0 Professional 8 July 25th, 2007 09:17 AM
Build & Publish Soporose Visual Basic 2005 Basics 1 December 28th, 2006 09:56 AM
Usizing issue Access to SQL Server gvcooper Pro VB 6 0 April 30th, 2006 05:09 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.