How to programatically detemine if a database has a merge subscription.

• Mark Johnson-176476

  SSCommitted

  Points: 1603

  More actions

  November 16, 2007 at 9:39 am

  #184314

  Is there a good way that will work with both SQL 2005 and SQL 2000 to determine within a stored proc if a database is a subscriber in a merge replication?

  What we have done in SQL 2000 is check for the existence of the sysmergesubscriptions table with a row where the subid does not match the partnerid. In SQL 2005 the partnerid column has changed to pubid.

  Is there a cleaner way?

  I need a SP that will work on both.

  Thanks.

• Mark Johnson-176476

  SSCommitted

  Points: 1603

  More actions

  November 16, 2007 at 10:06 am

  #751903

  Actually PubID exists in both but PartnerID was removed in SQL 2005.

  I could probably use PubID for my purposes but still wonder if there is a cleaner way.

  Thanks.

• Chris Becker

  SSCrazy

  Points: 2645

  More actions

  November 19, 2007 at 12:42 pm

  #752431

  You have a view on both pub & subscribers exposing merge article info:

  sysmergeextendedarticlesview

  and a table w/ 1 row for each merge pub defined in pub & subscr db's

  sysmergepublications

  ChrisB MCDBA

  MSSQLConsulting.com

  Chris Becker bcsdata.net