Posted by Hilary Cotter on 06/15/07 02:54

Drill down on the publication in the replication folder\Local Publications.
Right click on it and select Generate Scripts.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<bourgon@gmail.com> wrote in message
news:1181857951.236214.261320@o11g2000prd.googlegroups.com...
> I'm getting this, after upgrading from 2000 to 2005.
>
> Replication-Replication Distribution Subsystem: agent (null) failed.
> The subscription to publication '(null)' has expired or does not
> exist.
>
> The only suggestions I've seen are to dump all subscriptions. Since
> we have several dozen publications to several servers, is there a
> decent way to script it all out, if that's the only suggestion?
>
> Thanks in advance.
>

[Back to original message]