SQL Server 2005 replication - indicate data is replicated
I am using SQL Server 2005 replication to replicate data from one table on a server开发者_运维技巧 to the a table on a remote server. This is happening in real time. i.e whenever the data is changed at the publisher, it is then replicated to the subscribers.
From the publisher's server I need to know what data has been replicated to the subscriber. Is there a way to figure this out using SQL?
thanks
select publ.pk_col FROM pubdb.dbo.tbl publ JOIN linked_server_subscriber.pubdb.dbo.tbl subs ON publ.pk_col = subs.pk_col
精彩评论