Delete orphan subscription

I can't synchronize tables between 2 databases (in 2 diferent sites), but only specified tables. I found a orphan subscription with this tables, and I try to delete, but I can't.
I think this is the cause of the problem.
Please, anybody knows how can I delete this orphan subscriptions?

Thank you
eamigoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim P.Connect With a Mentor Commented:
run this on the publisher and subscriber:   sp_removedbreplication [ @dbname = ] 'dbname'

http://www.sqlservercentral.com/Forums/Topic184380-7-1.aspx#bm184453
--------------------------------
I found the above with a quick search. The easiest way is to totally blow it out and then recreate from scratch.

There was a way to blow it out on individual tables in SQL 7, but that is questionable, and can leave your DB out of sync.
0
 
eamigoAuthor Commented:
thank you
0
 
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0
All Courses

From novice to tech pro — start learning today.