Thursday, June 16, 2011

T-SQL script to remove replication in SQL server 2008\2005

use master
go

-- Remove replication objects from the subscription database on MYDATABASE.
DECLARE @subscriptionDB AS sysname
SET @subscriptionDB = N'MYDATABASE'

-- Remove replication objects from a subscription database (if necessary).
USE master
EXEC sp_removedbreplication @subscriptionDB
GO

use distribution
go
exec sp_removedistpublisherdbreplication @publisher = 'Instance Name'
, @publisher_db = 'MYDATABASE'

No comments:

Post a Comment