Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also...
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...( read more )