MSdistribution_status (Transact-SQL)

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.

See Also

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

How Transactional Replication Works

Help and Information

Getting SQL Server 2005 Assistance