Hi. I have SQL Server 2005 Standrad Editions publisher and 3 subscribers.
I had a publication with 3 subscriptions. For some reason i had to delete one of the subscription.
At the time of deletion for the first time on the publication server, it didnot return any errors.
Then when i tried to recreate it at the publisher, it gave me message that it already exists.
Now when i try to delete it at the publisher (both by seleting the check box to connect to subscriber n deleting or unchecking the check box), it fails saying there is no such subscriber.
I can go to the subscriber server, under replications and subscritpuions, i can delete it. But after few minutes or so, it shows up again automatically.
In replication monitor i donot see that particular subscription under the publication
In the Distribution database, i donot see the entry of the subscriber in MSmerge_subscriptions table
But in the database on which replication is taking place, i do see the jargon entries of the subscriber in the System table
When i delete those entries with delete statements, they show up again in the table after a few minutes.
I ran SQL server profiler to try and understand whats happening. My suspect is its something to do with the execution of the
View Complete Post