¿Cómo saber que tablas están replicadas?
2011/10/21 Leave a comment
--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
Alesón Consultores
desarrolleMOSS
