It may be simple but I find it difficult to delete a subscription. When I
right click the subscription I don't get this option and I can only delete
it by deleting the Publication
If this is SQL 2005, go to the subscriber and delete it from the local
subscriptions folder.
You should also be able to expand the publication on the publishers folder
so that you can see the subscriptions, right click on it there and select
delete.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:OyUYiqi4GHA.1460@.TK2MSFTNGP05.phx.gbl...
> It may be simple but I find it difficult to delete a subscription. When I
> right click the subscription I don't get this option and I can only delete
> it by deleting the Publication
>
|||Thank you,
I use SQL Server 2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eAHRq3i4GHA.4256@.TK2MSFTNGP03.phx.gbl...
> If this is SQL 2005, go to the subscriber and delete it from the local
> subscriptions folder.
> You should also be able to expand the publication on the publishers folder
> so that you can see the subscriptions, right click on it there and select
> delete.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:OyUYiqi4GHA.1460@.TK2MSFTNGP05.phx.gbl...
>
|||Right click on the publication, select properties, click on the
subscriptions tab, and delete it there.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:eq3QUKn4GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Thank you,
> I use SQL Server 2000
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eAHRq3i4GHA.4256@.TK2MSFTNGP03.phx.gbl...
>
|||Thank you but it doesn't appear on that list
Any suggestions why?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u5kopMq4GHA.2264@.TK2MSFTNGP02.phx.gbl...
> Right click on the publication, select properties, click on the
> subscriptions tab, and delete it there.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:eq3QUKn4GHA.3736@.TK2MSFTNGP02.phx.gbl...
>
|||Is this 2000 or 2005?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:uyNRgCx4GHA.4832@.TK2MSFTNGP06.phx.gbl...
> Thank you but it doesn't appear on that list
> Any suggestions why?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u5kopMq4GHA.2264@.TK2MSFTNGP02.phx.gbl...
>
|||2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u4oykx24GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Is this 2000 or 2005?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:uyNRgCx4GHA.4832@.TK2MSFTNGP06.phx.gbl...
>
No comments:
Post a Comment