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

Leave a Reply

Your email address will not be published. Required fields are marked *