I have been trying to un-subscribe a publication in a subscriber but there
is one article that fails to be un-subscribed. I tried to un-subsribe it
both from the subscriber and the publisher but never got it to work.
The reason I have to do this is the replication job from PUB to SUB failed
with an error message "Invalid Cursor State" and I could not restore the job
to normal. I thought I could just reestablish the pull subscription to
resolve the issue but apparently it did not work.
I would appreciate any help you can offer.
BTW, the same publication was replicated to 2 subscribers, the other
replication was working fine.