MSsubscription_agents (Transact-SQL)


Applies To: SQL Server

The MSsubscription_agents table is used by Distribution Agent and triggers of updateable subscriptions to track subscription properties. This table is stored in the subscription database.

Column nameData typeDescription
idintThe ID of the row.
publishersysnameThe name of the Publisher.
publisher_dbsysnameThe name of the publication database.
publicationsysnameThe name of the publication.
subscription_typeintThe subscription type:

0 = Push.

1 = Pull

2 = Pull anonymous.
queue_idsysnameThe ID of the Microsoft Message Queue at the Publisher. queue_id is set to SQL for SQL-based queued updating.
update_modetinyintThe type of updating:

 0 = Read-only.

 1 = Immediate update.

 2 = Queued update using Message Queuing.

 3 = Immediate update with queued update as failover using Message Queuing.

 4 = Queued update using SQL Server queue.

 5 = immediate update with queued update failover, using SQL Server queue.
failover_modebitIf a failover type of updating was select, this is the type of failover chosen:

 0 = Immediate update is being used. Failover is not enabled.

 1 = Queued update is being used. Failover is enabled. The queue being used for failover is specified in the update_mode value.
spidintThe system process ID for the connection used by the Distribution Agent that is currently running or has just run.
login_timedatetimeThe date and time of the Distribution Agent connection that is currently running or has just run.
allow_subscription_copybitSpecifies whether or not the ability to copy the subscription database is allowed.
attach_stateintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
attach_versionbinary(16)The unique identifier representing the version of an attached subscription.
last_sync_statusintThe last run status of the Distribution Agent that is currently running or has just run. The status can be:

 1 = Started.

 2 = Succeeded.

 3 = In progress.

 4 = Idle.

 5 = Retry.

 6 = Fail.
last_sync_summarysysnameThe last message of the Distribution Agent that is currently running or has just run. The status can be:



 In progress.



last_sync_timedatetimeThe date and time when the last_sync_summary and last_sync_status columns were updated. Pull or anonymous distribution agents running as SqlServer Agent Service jobs do not update these columns. The history information instead logs to the job history table in that case.
queue_serversysnameInternal use only.

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

Community Additions