Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srivatsahg
Yak Posting Veteran
71 Posts |
 Posted - 2009-11-04 : 03:49:51
|
Hello All
Can i use the stored procedure sp_droppublication to stop the ongoing replication.?
If yes, can i use it from a remote machine to turn off the replication ??
Regards
Srivatsa
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-04 : 06:24:54
|
for dropping replication, generate SQL replication script using "To drop or disable the componenets" option & use accordingly. You should drop the subscription before removing the publication. The steps for merge for instance should be
-- Dropping the merge subscriptions
exec sp_dropmergesubscription
-- Dropping the merge articles
exec sp_dropmergearticle
-- Dropping the merge publication
exec sp_dropmergepublication
Thanks,
Krishna
www.SQLServer.in |
 |
|
|
srivatsahg
Yak Posting Veteran
71 Posts |
Posted - 2009-11-04 : 10:46:12
|
Can i use the following scripts from a remote machine ??
|
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-05 : 05:05:08
|
don't do it from local system, could do from a remote server by adding the source server to object explorer. I normally do it from a publisher or subscriber machine.
Thanks,
Krishna
www.SQLServer.in |
|
|
|
|
|
|
Stop replication using scripts