Details | |
Product: | SQL Server |
Event ID: | 20010 |
Source: | MSSQLServer |
Version: | 8.0 |
Component: | SQL Engine |
Message: | The Snapshot Agent corresponding to the publication ‘%s’ could not be dropped. |
Explanation | |
This error occurs when dropping a merge replication publication. sp_dropmergepublication cannot drop the Snapshot Agent for the specified publication. The specified publication name may not exist in the publishing database. Perhaps a prior attempt to remove replication from the database did not completely remove all remnants of merge replication. | |
User Action | |
If other errors occur at the same time as this error, troubleshoot them first.
Run SQL Profiler against the relevant SQL Server instance to capture “Errors and Warnings” events. Sometimes this will capture errors that are otherwise not seen. You may need to manually remove the replication. For more information about how to manually remove replication, see Microsoft Knowledge Base article 324401. |