Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ygeorge
Yak Posting Veteran
68 Posts |
 Posted - 2004-11-08 : 18:31:10
|
| Hi,I guess it's a common problem because I just began to play around with sql server replication -I defined a replication from a server to another (just right-clicked on the right pane, chose New Publication..., then went through). Then I went to the target server and found an entry showing up in the Subscriptions folder. Then I decided to remove the subscriber. I went to the publisher, right-clicked the properties of the publisher, in the Subscriptions tab, I clicked the Delete button. So far, everything is good. But when I went to the target server to double-check the Subscriptions folder, that entry is still there. Can anyone let me know why was that, and how to remove that entry?Thanks,George |
|
|
ygeorge
Yak Posting Veteran
68 Posts |
Posted - 2004-11-08 : 18:54:55
|
| Just figured out - Run sp_subscription_cleanup 'Publisher','Publisher_DB'in the subscription database. |
 |
|
|
|
|
|
Unable to remove subscriber