<div>
If using or planning to use SQL Replication I suggest you get familiar and use following SQL internal stored procedures:<br />
<br />
&quot;How to: Programmatically Monitor Replication&quot;<br />
<a href="http://msdn.microsoft.com/en-us/library/ms147874.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms147874.aspx</a>
</div>


<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I have to check replication between Publishers and subscribers.<br />
<br />
SO I need to get the counts on all the published articles from source and destination servers. <br />
However, instead of running individual count(*) statements for each table on both the servers, I wanted to see if there can be a query which can insert the results from count(*) in a table for all the articles.<br />
<br />
Table &nbsp; &nbsp; &nbsp;Source &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Count &nbsp; &nbsp; &nbsp; &nbsp;Destination &nbsp; Count<br />
Tbl1 &nbsp; &nbsp; &nbsp; &nbsp; server1:Pub &nbsp; &nbsp;1000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;server2.Sub &nbsp;908<br />
Tbl2 &nbsp; &nbsp; &nbsp; &nbsp; server1:Pub &nbsp; &nbsp;29 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;server2.Sub &nbsp;29<br />
....<br />
....<br />
<br />
I need advice on how to write a query to achieve this result set.<br />
Thanks,<br />
-B
</div>
</div>


Hello All,

I have to check replication between Publishers and subscribers.

SO I need to get the counts on all the published articles from source and destination servers. 
However, instead of running individual count(*) statements for each table on both the servers, I wanted to see if there can be a query which can insert the results from count(*) in a table for all the articles.

Table      Source              Count        Destination   Count
Tbl1         server1:Pub    1000          server2.Sub  908
Tbl2         server1:Pub    29              server2.Sub  29
....
....

I need advice on how to write a query to achieve this result set.
Thanks,
-B

If using or planning to use SQL Replication I suggest you get familiar and use following SQL internal stored procedures:

&quot;How to: Programmatically Monitor Replication&quot;
http://msdn.microsoft.com/en-us/library/ms147874.aspx

Row count in a table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.