Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server Replication (SSQA.net)

Another methodology to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
How to find subscriber is not getting upto date data?

Run the following TSQL to get details of  troubled subscribers that are not getting upto date data:

select agent_id from msdistribution_status 
group by agent_id 
having sum(undelivCmdsInDistDB) >1000 
order by sum(undelivCmdsInDistDB) desc

Posted: Friday, December 14, 2007 6:18 PM by SQL Master

Comments

SSQA.net - SqlServer-QA.net said:

Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select

# December 14, 2007 6:44 PM

Other SQL Server Blogs around the Web said:

Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select

# December 14, 2007 6:47 PM
Anonymous comments are disabled