| Event Id | 14006 |
| Source | MSSQLServer |
| Description | Could not drop the publication. |
| Event Information | CAUSE: 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 Links | Microsoft 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.