Server A publishes Pub1, Server B subscribes to Pub1.

Server A and Server B are both SQL Server 2012 Standard Edition, default instances.

When I use Replication Monitor to drop-in a Tracer Token, one publisher-subscriber shows-up passing the token as expected.

When I run sp_helpsubscription 'Pub1' on Server A, one subscription shows-up as expected.

When I expand Replication->Local Subscriptions in SSMS on Server B, two identical subscriptions show-up.

What's going on? Which subscription should I delete at Server B?

  • 1
    Hi Erik, try to execute the following query on the subscriber database (the one on server b): SELECT distinct publisher, publisher_db, publication, time, transaction_timestamp, subscription_guid FROM dbo.MSreplication_subscriptions ORDER BY 1,2,3
    – Giova
    Jan 25, 2016 at 10:44
  • @Giova, 2 rows are returned, one for each subscription. The first 3 columns are identical, the last 3 columns differ.
    – SethB
    Jan 26, 2016 at 20:35

1 Answer 1


Giova's query brought into sharper focus the name of the publication; Pub 1 vs. Pub_1, for example.

The difference between the two subscriptions was the under-bar, '_', character in the name of the publication.

The subscription referencing the non-existent publication was deleted.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.