I am very new to SQL replication and Enterprise manager, so please be specific where I run stuff.
Server A - Publisher and Distributer
Server B - Subscriber
I created a Push Merge publication on Server A to Server B and everything was working.
I deleted the publication from Server A and I thought that would remove it from Server B.....NOT!
So now I have this 'orphan' subscription on Server B and I can't get rid of it. It is locking me out of the replicated tables so I can't create a new publication that replicates the same tables as the first one.
The subscription line on Server B looks like this:
Name: EDL-ESDIII01:Apps:Manila Tables
Last action: No data needed to be merged
Replication Type: Merge
I've tried everything I know, which is little in this instance, I've shutdown replication on Server A, rebooted both servers, etc...
Please Help! I'm under the gun to get this working.
Thanks for the reply. I ran sp_helpmergesubscription and the offending subscription was shown. I ran sp_dropmergesubscription (not exactly as you typed) but it objected to (a) no publication and then (b) the non existence of the the publication (copied from the detail in sp_helpmergesubscription). Of course, that publication is not there - I dropped it in Enterprise Manager! It feels like catch22..... Q. What table/database holds the information that sp_helpmergesubscription uses to display its detail?
run it at SERVERB
UPDATE sysobjects SET replinfo=0 WHERE xtype='U'
--make sure ALLOW UPDATE SYSTEM CATALOG is checked in server
Take the backup b4 doing this. I squared it away once using this.
Also if u restore a replicated database, without explicitly specifying KEEP_REPLICATION option, replication is not preserved. So u can also try backing up ur subscriber and the restoring it.