Event ID - 14006

Event Id14006
DescriptionCould not drop the publication.
Event InformationCAUSE:
If you tried to drop a transactional or snapshot publication, the error occurs when the specific row cannot be deleted from MSpublications.
If you tried to drop a merge publication, the error occurs in any of the following circumstances:

1. The relevant rows cannot be updated in or deleted from one or more of the following tables, perhaps because of insufficient permissions or a missing table: MSmerge_genhistory, MSmerge_replinfo, MSpublications, sysmergearticles, sysmergepublications, sysmergeschemaarticles, sysmergeschemachange, sysmergesubscriptions, or sysmergesubsetfilters.
2. A related dynamic snapshot job cannot be dropped.
3. Any error occurred in removing the publications articles or their generation history.
4. If the publication was the last one in the database, the process tried to truncate the tables MSmerge_genhistory, MSmerge_contents, and MSmerge_tombstone, and one or more of the truncate statements returned an error.
5. If the error is returned along with 20040, "Could not drop the article(s) from the publication %s," one or more articles could not be dropped through the stored procedure sp_dropmergearticle.
6. If the error is returned along with 20010, "The Snapshot Agent corresponding to the publication %s could not be dropped," there was a problem with dropping the Snapshot Agent with the stored procedure sp_MSdropmergepub_snapshot.
7. If the error is returned along with 14071, "Could not find the Distributor or the distribution database for the local server. The Distributor may not be installed, or the local server may not be configured as a Publisher at the Distributor," there was an error calling sp_helpdistributor for the specified publication.
8. If the error is returned along with 21254, "The Active Directory operation on publication %s could not be completed because Active Directory client package is not installed properly on the machine where SQL Server is running," or 21369, "Could not
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 14006

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.