Roy,
I have no idea what 'hand picture' is, but to disable
replication on the database you can use sp_dboption or
databasepropertyex. To use sp_dboption, pass the database
name as the parameter.
published
merge publish
and set the above parameters to false.
Rgds,
Paul Ibison, SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Other than what Paul said you can also go to tools, replication, configure
publishers, distributor, and subcribers; and click on the publication
databases tab, and then uncheck the databases you want to stop
sharing/publishing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
Thursday, March 22, 2012
Deleting Database with replication
Labels:
database,
deleting,
disablereplication,
hand,
idea,
microsoft,
mysql,
oracle,
ordatabasepropertyex,
picture,
replication,
roy,
server,
sp_dboption,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment