 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / September 2006Delete a subscription
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.  SignatureHilary 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 > 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 > If this is SQL 2005, go to the subscriber and delete it from the local > subscriptions folder. [quoted text clipped - 6 lines] >> right click the subscription I don't get this option and I can only >> delete it by deleting the Publication Right click on the publication, select properties, click on the subscriptions tab, and delete it there. SignatureHilary 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 > Thank you, > [quoted text clipped - 10 lines] >>> I right click the subscription I don't get this option and I can only >>> delete it by deleting the Publication Thank you but it doesn't appear on that list Any suggestions why? > Right click on the publication, select properties, click on the > subscriptions tab, and delete it there. [quoted text clipped - 13 lines] >>>> I right click the subscription I don't get this option and I can only >>>> delete it by deleting the Publication Is this 2000 or 2005? SignatureHilary 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 > Thank you but it doesn't appear on that list > [quoted text clipped - 17 lines] >>>>> When I right click the subscription I don't get this option and I can >>>>> only delete it by deleting the Publication 2000 > Is this 2000 or 2005? > [quoted text clipped - 19 lines] >>>>>> When I right click the subscription I don't get this option and I can >>>>>> only delete it by deleting the Publication |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.