Tag: sp_droparticle

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-5d860a197180b794116795/] 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 »