开发者

SQL Server 2005 replication - indicate data is replicated

开发者 https://www.devze.com 2023-01-04 22:01 出处:网络
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 a

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

0

精彩评论

暂无评论...
验证码 换一张
取 消