You have 4 tables For transactional replication (push subscription) at the subscriber's side: - [MSreplication_objects][1] > contains one row for each object that is associated with replication > in the Subscriber database - [MSreplication_subscriptions][2] > contains one row of replication information for each Distribution > Agent servicing the local Subscriber database - [MSsubscription_agents][3] > is used by Distribution Agent and triggers of updateable subscriptions > to track subscription properties - [MSsnapshotdeliveryprogress][4] > is used to track files that have been successfully delivered to the > Subscriber when a snapshot is being applied ---------- you can use this columns to monitor the status for your replication at the subscriber's side SELECT login_time, last_sync_status, last_sync_summary, last_sync_time, spid FROM dbo.MSsubscription_agents [1]: https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/msreplication-objects-transact-sql "MSreplication_objects" [2]: https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/msreplication-subscriptions-transact-sql/ "MSreplication_subscriptions" [3]: http://learn.microsoft.com/en-us/sql/relational-databases/system-tables/mssubscription-agents-transact-sql [4]: http://learn.microsoft.com/en-us/sql/relational-databases/system-tables/mssnapshotdeliveryprogress-transact-sql