Skip to content

Latest commit

 

History

History
43 lines (38 loc) · 1.52 KB

File metadata and controls

43 lines (38 loc) · 1.52 KB
title MSdistribution_status (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/03/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
replication
ms.tgt_pltfrm
ms.topic language-reference
applies_to
SQL Server
f1_keywords
MSdistribution_status_TSQL
MSdistribution_status
dev_langs
TSQL
helpviewer_keywords
MSdistribution_status view
ms.assetid 90d447de-3a4a-4f3e-aeab-e8fff6348361
caps.latest.revision 12
author BYHAM
ms.author rickbyh
manager jhubbard

MSdistribution_status (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)