Removes all replication objects from a database without updating data at the Distributor.
sp_removedbreplication [@dbname =] 'dbname'
0 (success) or 1 (failure)
sp_removedbreplication is used in all types of replication.
sp_removedbreplication is useful when restoring a replicated database that has no replication objects needing to be restored.
Only members of the sysadmin fixed server role can execute sp_removedbreplication.
System Stored Procedures |