Thursday, March 29, 2012

delete database that participates in replication

Does anyone know of abbreviated T-SQL that would sure-fire delete a set of
databases that participate in replication ?
I would like to do this without writing T-SQL to
-- Drop the transactional subscription
-- Drop the transactional articles (every table in publication database)
-- Drop the transactional publication
-- Disable the replication database
-- Drop the registered subscriber
-- Uninstall the server as a Distributor.
John,
you could try something like this:
alter database distribution set single_user with rollback immediate
exec sp_dropdistributor @.no_checks = 1
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

No comments:

Post a Comment