"dbapaul" <psheehan@smcteam.com> wrote in message
news:bf01fcc9.0408130956.4c06339d@posting.google.com...
> These errors occur at the subscriber. First, "The merge process could
> not query the last sent and received generations" is generated, then
> immediately afterwards, "invalid cursor state" is generated. We are
> trying to pull a new subscription snapshot from the republisher. The
> subscriber has been added and removed from the replusher's pull
> subscriptions a number of times for testing. Now, we cannot get the
> subscriber to re-sync with the republisher. Any ideas?
>
> Thanks,
> Paul

"Hilary Cotter" <hilaryk@att.net> wrote in message news:<euDdBrhgEHA.3320@TK2MSFTNGP11.phx.gbl>...
> Is this error reproducible? It is normally a transient error, and goes away
> when you run the merge agent again. It is normally not accompanied by the
> invalid cursor state message.
>
> You will have to try to isolate this problem to the database, subscriber or
> publisher. Can you try to pull the subscription to another database on the
> subscriber? If this fails, the problem could be subscriber specific. Try to
> pull it to another subscriber? If it works, the problem is subscriber
> specific. If it does not work it is probably a problem with the Publisher.
>
> If the problem is subscriber specific, reapply the latest sp, and see what
> happens.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "dbapaul" <psheehan@smcteam.com> wrote in message
> news:bf01fcc9.0408130956.4c06339d@posting.google.com...
> > These errors occur at the subscriber. First, "The merge process could
> > not query the last sent and received generations" is generated, then
> > immediately afterwards, "invalid cursor state" is generated. We are
> > trying to pull a new subscription snapshot from the republisher. The
> > subscriber has been added and removed from the replusher's pull
> > subscriptions a number of times for testing. Now, we cannot get the
> > subscriber to re-sync with the republisher. Any ideas?
> >
> > Thanks,