0

We have a merge replication that sources on a subscription of a transactional replication. According to this source (Multiple SQL replication types) I need to set the @published_in_tran_pub to true.

So far so good, however now I would like to check if the property is indeed set to true. Does anyone know how to do this?

Microsoft: This merge replication example returns the properties of the published article. TSQL

DECLARE @publication AS sysname;
SET @publication = N'AdvWorksSalesOrdersMerge';

USE [AdventureWorks2012]
EXEC sp_helpmergearticle
 @publication = @publication;
GO

Unfortunately the above query does not return information about the @published_in_tran_pub property.

Thanks in advance

Community
  • 1
  • 1
user3248190
  • 101
  • 1
  • 10

1 Answers1

1

You can query sysmergearticles to check the value of the property @published_in_tran_pub.

Brandon Williams
  • 3,695
  • 16
  • 19
  • Thank you very much! Looking to your profile, it seems you have a lot of experience with replication. Could you be so kind to have a look at my post here: http://stackoverflow.com/questions/26999358/replicate-a-filtered-subset-of-data-merge-or-transactional-replication thanks again! – user3248190 Dec 02 '14 at 09:09