--Que tablas
están publicadas en Réplica de Mezcla y sus subscriptores
SELECT b.name AS [Table],
DB_NAME()
AS PublisherDB,a.subscriber_server AS Subscriber,
a.db_name AS SubscriberDB
from sysmergesubscriptions a, sysmergearticles b
where a.pubid=b.pubid
order by a.subscriber_server
--Que tablas
están publicadas en Réplica Transaccional y sus subscriptores
SELECT a.name AS [Table],
is_published AS is_tran_published,DB_NAME() AS PublisherDB,
c.srvname AS Subscriber,
c.dest_db AS SubscriberDB
FROM sys.tables a
INNER JOIN dbo.sysarticles b ON a.object_id = b.objid
INNER JOIN dbo.syssubscriptions c ON b.artid = c.artid
WHERE is_published = 1
