| Event Id | 20007 |
| Source | MSSQLServer |
| Description | The system tables for merge replication could not be dropped successfully. |
| Event Information | CAUSE: This error is raised in sp_MSdrop_mergesystables. sp_MSdrop_mergesystables is called when you try to remove merge replication from a database or from an entire instance of SQL Server. The error indicates that one or more of the merge system tables could not be dropped for any number of reasons. RESOLUTION: 1. Check for and then troubleshoot any previous errors raised before this error. 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. 3. Use DBCC CHECKDB to verify the integrity of the database with the merge replication system tables. 4. Try the removal process again when no users are in the database. 5. Manually remove replication piece by piece. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 20007 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.