Error 14046: Could not drop article. A subscription exists on it.
I get the above error when I try to drop a publication in SQL2k. I do not
show any subscriptions for this publication anywhere. How can I find the
subscription that is blocking me from dropping this publication?
Nevermind, I got it.
In distribution..MSsubscriptions, I found the "rogue" entry, causing this
error. I deleted it, and was then able to successfully delete the
publication.
"JAdams" wrote:
> Error 14046: Could not drop article. A subscription exists on it.
> I get the above error when I try to drop a publication in SQL2k. I do not
> show any subscriptions for this publication anywhere. How can I find the
> subscription that is blocking me from dropping this publication?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment