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. [crayon-5cbd80ac635a2057915049/] Consider the following scenario. Transactional Replication is set on the database from a script and sp_addarticle was used to Publish some of the replication systems tables (in this case, MSpeer_lsns table). When you try to restore the
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 »