View tables in SQL Server transactional replication

Publié le 7 juin 2025 à 19:19

 USE [Your publication DB]

select
db_name() PublisherDB
, sp.name as PublisherName
, sa.name as TableName
, UPPER(srv.srvname) as SubscriberServerName, [s].[dest_db], [sa].[description], [sa].[ins_cmd], [sa].[upd_cmd], [sa].[del_cmd], [s].[login_name]
from dbo.syspublications sp
join dbo.sysarticles sa on sp.pubid = sa.pubid
join dbo.syssubscriptions s on sa.artid = s.artid
join master.dbo.sysservers srv on s.srvid = srv.srvid
ORDER BY srv.srvname, sa.name

Évaluation: 0 étoile
0 vote

Ajouter un commentaire

Commentaires

Il n'y a pas encore de commentaire.