Breaking News: Grepper is joining You.com. Read the official announcement!

script for how to remove replication in sql server

velpula sandeep answered on June 18, 2023 Popularity 3/10 Helpfulness 4/10

answer script for how to remove replication in sql server

script for how to remove replication in sql server

Comment

-- Step 1: Disable the replication on the published database
USE master;
EXEC sp_replicationdboption 'YourDatabaseName', 'publish', 'false';
GO

-- Step 2: Delete the publication and articles
USE YourDatabaseName;
EXEC sp_droppublication @publication = 'YourPublicationName';
GO

-- Step 3: Delete the subscription(s) if applicable
USE YourDatabaseName;
EXEC sp_dropsubscription @publication = 'YourPublicationName', @subscriber = 'YourSubscriberServerName', @destination_db = 'YourSubscriberDatabaseName';
-- Repeat the above line for each subscription you want to remove
GO

-- Step 4: Delete the replication objects
USE YourDatabaseName;
EXEC sp_removedbreplication;
GO

Popularity 3/10 Helpfulness 4/10 Language sql

Source: chat.openai.com

Tags: script sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 18 2023

velpula sandeep

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

script for how to remove replication in sql server

Contents

More Related Answers

script for how to remove replication in sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.