Re: Drop Merge Pull Subscription at Publisher?

From: Deepak (deepakjgupta_at_hotmail.com)
Date: 03/18/04 

Date: 18 Mar 2004 10:45:10 -0800

Hi Baisong,

I am facing the same problem as Lance.

The issue here is, when a login who is in the PAL has the permission
to call sp_addmergesubscription on the Publisher, why can't the same
login call sp_dropmergesubscription also on the Publisher.

This is NOT an issue with sp_addsubscription and sp_dropsubscription
on the Publisher for a login who is in the PAL.

Thanks.

Deepak.

v-baiwei@online.microsoft.com (Baisong Wei[MSFT]) wrote in message news:<w6H24$ODEHA.756@cpmsftngxa06.phx.gbl>...
> 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

  • Re: "Text column data incomplete" error during replication
    ... Looking for a SQL Server replication book? ... Could not find stored procedure 'sp_MSupd_Entity Address'. ... > Disconnecting from Subscriber '' ... > properties tab of this publictaion at the Publisher, ...
    (microsoft.public.sqlserver.replication)
  • Re: two questions
    ... I take it you have a criteria to filter on. ... on the browse button to the right of your stored procedure and select the ... Looking for a SQL Server replication book? ... > distributor runs on publisher. ...
    (microsoft.public.sqlserver.replication)
  • Re: [PHP] access to DB and security
    ... If i use this login + password to connect and perform some actions ... only execute some stored procedure but can not administrate my DB. ... One is to switch to a host, perhaps a dedicated host, where you DO ... business process and authentication model looks like... ...
    (php.general)
  • Re: two questions
    ... I have 3 subscribers and 1 publisher. ... > on the browse button to the right of your stored procedure and select the ... > parameter on every unc deployed subscriber. ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Limiting views on data in a table
    ... >returns the Windows login the user uses to connect to SQL Server. ... >use it in the WHERE clause of your single stored procedure for everybody to ... pass the login name as a parameter in the stored procedure). ...
    (microsoft.public.sqlserver.security)