Event ID - 20007

Event Id20007
DescriptionThe system tables for merge replication could not be dropped successfully.
Event InformationCAUSE:
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.

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 LinksMicrosoft 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.

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.