Showing posts with label participate. Show all posts
Showing posts with label participate. Show all posts

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