how to delete push subscription

Hi All:
i did disable publishing and distribution , but still leave a push
subscription in DB , how can i delete it , otherwise i can not modify the
Database which is doing push subscription.
Cheers
nick
Nick,
try using sp_removedbreplication.
Rgds,
Paul Ibison
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:Og7BO7wCFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> i did disable publishing and distribution , but still leave a push
> subscription in DB , how can i delete it , otherwise i can not modify the
> Database which is doing push subscription.
>
> Cheers
> nick
>
|||Thanks Paul
it works.
Cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:u7L9TRxCFHA.2072@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Nick,
> try using sp_removedbreplication.
> Rgds,
> Paul Ibison
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:Og7BO7wCFHA.3728@.TK2MSFTNGP14.phx.gbl...
the
>

how to delete distribution database

Hi Friends,
SQL 2000
I resotred a backup of distribution db as d21 and now when I am tryiong to
delete this db , it does not let me to do so, saying , database in
replication.
How can I delete the d21 database ?
The repplication is on and going now.
Thanks,
PatrickHi
Have you run sp_removedbreplication ?
John
"Patrick" wrote:

> Hi Friends,
> SQL 2000
> I resotred a backup of distribution db as d21 and now when I am tryiong to
> delete this db , it does not let me to do so, saying , database in
> replication.
> How can I delete the d21 database ?
> The repplication is on and going now.
>
> Thanks,
> Patrick
>
>|||Yes I did, and stil it doesn't let me to delete the d21 database.
"John Bell" <jbellnewsposts@.h0tmail.com> wrote in message
news:4B80A39F-2A2D-4C5D-B395-1F8925305BC5@.microsoft.com...
> Hi
> Have you run sp_removedbreplication ?
> John
> "Patrick" wrote:
>|||Hi
You may want to look at step 2 in
http://support.microsoft.com/kb/190797/EN-US/
John
"Patrick" wrote:

> Yes I did, and stil it doesn't let me to delete the d21 database.
>
> "John Bell" <jbellnewsposts@.h0tmail.com> wrote in message
> news:4B80A39F-2A2D-4C5D-B395-1F8925305BC5@.microsoft.com...
>
>