This topic has not yet been rated - Rate this topic

MSdistribution_status (Transact-SQL)

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005
SQL Server 2012

The MSdistribution_status view exposes additional information on the status commands in the distribution database. This view is stored in the distribution database.

Column name	Data type	Description
article_id	int	Identifies an article.
agent_id	int	Identifies a replication agent.
UndelivCmdsInDistDB	int	The number of commands pending delivery to Subscribers.
DelivCmdsInDistDB	int	The number of commands delivered to Subscribers.

Reference

Replication Views (Transact-SQL)

Concepts

How Transactional Replication Works

Replication Tables (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD