Where can I see the @published_in_tran_pub property?

Question

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

Answer 1

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