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
Thursday, March 29, 2012
delete database that participates in replication
Labels:
abbreviated,
database,
delete,
microsoft,
mysql,
ofdatabases,
oracle,
participate,
participates,
replication,
server,
sql,
sure-fire,
t-sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment