Remove Replication

-- Dropping the transactional subscriptions

use [DBA]

exec sp_dropsubscription @publication = N'ReplicationPublicationName', @subscriber = N'KCRCSTVSQL03', @destination_db = N'DestinationDB', @article = N'all'

GO

 

-- Dropping the transactional articles

use [DBA]

exec sp_dropsubscription @publication = N'ReplicationPublicationName', @article = N'Action', @subscriber = N'all', @destination_db = N'all'

GO

 

-- Dropping the transactional publication

use [DBA]

exec sp_droppublication @publication = N'ReplicationPublicationName'

GO

 

DECLARE @publicationDB AS sysname;

DECLARE @publication AS sysname;

SET @publicationDB = N'DBA';

SET @publication = N'ReplicationPublicationName';

 

-- Remove a transactional publication.

USE COMMON

EXEC sp_droppublication @publication = @publication;

 

-- Remove replication objects from the database.

USE [master]

EXEC sp_replicationdboption

  @dbname = @publicationDB,

  @optname = N'publish',

  @value = N'false';

GO