all groups > sql server replication > july 2005 >
You're in the

sql server replication

group:

SQL Server Replication Record Count


SQL Server Replication Record Count Ben
7/7/2005 2:43:06 PM
sql server replication: Hi,

When a SQL Server Subscriber is running, is there any way to determine the
total number of records that is being replicated? And also how many records
are left before replication is completed?

Thanks for your help

Re: SQL Server Replication Record Count Paul Ibison
7/8/2005 9:26:23 AM
There's a Status callback on the merge activeX control which gives this
info. For transactional, you could do a read of the transaction_timestamp in
MSreplication_subscriptions and compare it to sp_browsereplcmds on the
distributor. This is not exact, but might give you an idea.
HTH
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button