July 26, 2005 at 2:38 pm
Hi there,
Sometimes I forget to delete the subscription before deleting the replication. Then if the published database is deleted/not there anymore, the subscription is orphaned, but still shows up in Query Analyzer under Subscriptions folder.
I ran
sp_dboption 'database_name', subscribed, 'true' to no avail
I looked for the syssubscribtions table to delete the row from there, no joy.
Is there another way to get rid of this?
Thanks
July 27, 2005 at 8:18 am
At the subscriber, you should just be able to right click & delete the subscription
July 27, 2005 at 1:54 pm
Nope, just have the Help menu. Set Update Metjod is greyed out, there's no Delete at all.
July 28, 2005 at 4:40 am
for transactional replication delete the contents of these two rows
MSreplication_subscriptions
MSsubscription_agents
for merge follow these instructions
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply