How to know which tables are replicated?
2011/10/21 Leave a comment
--Which tables are published for Merge Replication and his subscribers 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 --Which tables are published for Transactional Replication and his subscribers 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
About Fran Lens
Alesón Consultores
desarrolleMOSS
