Event Id14005
SourceMSSQLServer
DescriptionCould not drop publication. A subscription exists to it.
Event InformationCAUSE:
You have tried to drop a publication that has one or more associated subscriptions. A publication can only be dropped if there are no associated subscriptions.

RESOLTUION:
Drop the subscriptions before dropping the publication. If you use SQL Enterprise Manager to drop the publication, it will give you the option to automatically drop all associated subscriptions before dropping the publication.
If no subscriptions appear to exist for the publication or if you see this error when you create a publication, you may have a previous subscription that was not completely cleaned up after it was removed. The exact steps to remove the leftover replication will depend on your situation.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 14005


  Did this information help you to resolve the problem?
  Yes: My problem was resolved.
  No: The information was not helpful / Partially helpful.
  Comments:

Captcha  Refresh