remove a push subscription from subscriber server

Hi all,
How do you remove a push subscription from subscriber server?
This is our Server and we get are data pushed every 15 minutes from a remote
server that
is not managed by us.
Once in a while they need to do a complete push of all the data and need the
subscription
removed. How? Since it is our server and our replicated data, how can I
remove it?
You cannot right click and delete.
thanks,
gv
You need to change the account that they are using to push the subscription.
Query
select distribution_agent from MSreplication_subscriptions to get the name
of the agent. Then run profiler filtering so that only this application name
comes through. Note the login and then change the password on it locally or
remove it from the database users or server roles.
http://www.zetainteractive.com - Shift Happens!
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
"gv" <gerry.viator@.accesspointinc.com> wrote in message
news:e5628BcQIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi all,
> How do you remove a push subscription from subscriber server?
> This is our Server and we get are data pushed every 15 minutes from a
> remote server that
> is not managed by us.
> Once in a while they need to do a complete push of all the data and need
> the subscription
> removed. How? Since it is our server and our replicated data, how can I
> remove it?
> You cannot right click and delete.
> thanks,
> gv
>