RE: Drop Merge Pull Subscription at Publisher?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 13:50:18 GMT

Hi Lance,

Based on my knowledge, when you create a merge subscription, there will be
a merge agent created. As your should run sp_dropmergesubscription to drop
this agent. sp_dropmergesubscription should be run at the Publisher on the
publication database . So, you cannot run it from the subscriber side. So,
I think it is true that it should be run by a DBA on the publisher side.

As for the other stored procedures you mentioned, you could refer to the
SQL Server Books Online, and you will notice for every stored procedure's
information, in the begining of each one's introduction, there will be
information of where this stored procedure should be run at and there will
be a Permission part, it will be informaiton about who could run this
stored procedure.

Hope this helps.

Thanks.

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages