| Event Information | "According To Microsoft:"
CAUSE:
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.
RESOLUTION:
1. If other errors occur at the same time as this error, troubleshoot them first.
2. 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. |
