This stored procedure is executed at the Publisher on the publication database or at the Subscriber on the subscription database. The procedure removes all replication objects from the database in which it is executed, but it does not remove objects from other databases, such as the distribution database.
|This procedure should be used only if other methods of removing replication objects have failed. For more information about these methods, see Removing Replication.|
- [ @dbname=] 'dbname'
Is the name of the database. dbname is sysname, with a default value of NULL. When NULL, the current database will be used.
- [ @type = ] type
Is the type of replication for which database objects are being removed. type is nvarchar(5) and can be one of the following values.
Removes transactional replication publishing objects.
Removes merge replication publishing objects.
Removes all replication publishing objects.
-- Remove replication objects from the subscription database on MYSUB. DECLARE @subscriptionDB AS sysname SET @subscriptionDB = N'AdventureWorksReplica' -- Remove replication objects from a subscription database (if necessary). USE master EXEC sp_removedbreplication @subscriptionDB GO
ReferenceSystem Stored Procedures (Transact-SQL)
Other ResourcesHow to: Disable Publishing and Distribution (Replication Transact-SQL Programming)