Tag: sp_removedbreplication

Restore of Replicated Database fails with “Cannot drop the table because it is being used for replication.”

Sateesh Yele Microsoft SQL Server Support Issue: Restore of a replicated database fails with the following message. Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 32 Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for replication. Consider the following scenario. Transactional Replication is set on the database from a script and sp_addarticle
Read More »

How to cleanup Replication Bits

For SQL 2005 and SQL 2008 the sp_removedbreplication stored procedure works great for removing the SQL Replication bits from a database.  SQL 2000 has an older version of this SP which doesn’t always cleanup the database.  You can use the following steps in SQL 2000 to remove the leftover Replication bits. Problem Description – Manually
Read More »