📅 2021-09-01 ✍️ Bart Schelstraete 🔄 Updated: 2026-02-21

How to check the number of messages in SQL Server replication distribution

SQL-Server

With this command you can check the number of transactions in the distribution database.

 SELECT count(*) 
  FROM [distribution].[dbo].[MSrepl_transactions]
  where entry_time > '2021-08-31 06:00:00.00' and entry_time < '2021-08-31 13:35:09.880'

Tags: how-to replication sql-server