Determinar Articulos y Subscriptores en Replicación de Mezcla y Transaccional
–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