"Alice Spencer" <nospam@here.com> wrote in message
news:e4VKwih2DHA.2428@tk2msftngp13.phx.gbl...
> Hello
> I am having problems setting up transactional replication and have a
couple
> of questions.
> I have a publisher, separate distributor and two subscribers (all SQL
2000)
> I create the publication OK (which includes tables, views and stored
> procedures), then a subscription which I set to every 30 minutes.
> I then start the snapshot agent and the snapshot is created OK.
> However when the distribution agent runs, it fails after a minute or so
with
> a 2571 error. - I think this is because one of the stored procedures is
> referencing a table that no longer exists. I have yet to get to the bottom
> of this.
> However, on the second subscriber, when the distribution agent runs, it
> completes successfully but does not apply any transactions even up until
the
> failure stage. The info' says the the 'snapshot is not yet available' -
but
> it is.
> Does this mean that if one subscription fails, the snapshot is somehow
> marked as 'bad' by SQL?
> Is there any way to tell at which point the distribution agent fails on
the
> first subscription or is it a question of reducing the number of stored
> procedure articles bit by bit to narrow it down ? - There are loads of
them.
> Thanks in advance for any tips.
> A Spencer.
>
>

"Kestas" <kicker@nospammm-mail.lt> wrote in message
news:uPcyUBn2DHA.1684@TK2MSFTNGP12.phx.gbl...
> I would suggest removing all stored procedures from your publication. Then
> you could initialize replication and afterwards could just simply script
> stored procedures to a file and then run this script on a subscriber. If
> script will fail at some points you will clearly see which parts of it are
> problematic.
>
> If you just want to find out which sp is causing problems, you can just
> script all tables and sp's to a separate files, run tables creation script
> on an empty database and afterwards run sp's creation script :)
>
> --
> _______________________
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
>
>
> "Alice Spencer" <nospam@here.com> wrote in message
> news:e4VKwih2DHA.2428@tk2msftngp13.phx.gbl...
> > Hello
> > I am having problems setting up transactional replication and have a
> couple
> > of questions.
> > I have a publisher, separate distributor and two subscribers (all SQL
> 2000)
> > I create the publication OK (which includes tables, views and stored
> > procedures), then a subscription which I set to every 30 minutes.
> > I then start the snapshot agent and the snapshot is created OK.
> > However when the distribution agent runs, it fails after a minute or so
> with
> > a 2571 error. - I think this is because one of the stored procedures is
> > referencing a table that no longer exists. I have yet to get to the
bottom
> > of this.
> > However, on the second subscriber, when the distribution agent runs, it
> > completes successfully but does not apply any transactions even up until
> the
> > failure stage. The info' says the the 'snapshot is not yet available' -
> but
> > it is.
> > Does this mean that if one subscription fails, the snapshot is somehow
> > marked as 'bad' by SQL?
> > Is there any way to tell at which point the distribution agent fails on
> the
> > first subscription or is it a question of reducing the number of stored
> > procedure articles bit by bit to narrow it down ? - There are loads of
> them.
> > Thanks in advance for any tips.
> > A Spencer.
> >
> >
>
>