Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSreplication_subscriptions (Transact-SQL)
Collapse the table of content
Expand the table of content

MSreplication_subscriptions (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The MSreplication_subscriptions table contains one row of replication information for each Distribution Agent servicing the local Subscriber database. This table is stored in the subscription database.

Column name

Data type

Description

publisher

sysname

The name of the Publisher.

publisher_db

sysname

The name of the Publisher database.

publication

sysname

The name of the publication.

independent_agent

bit

Indicates whether there is a stand-alone Distribution Agent for this publication.

subscription_type

int

The type of subscription:

0 = Push.

1 = Pull.

2 = Anonymous.

distribution_agent

sysname

The name of the Distribution Agent.

Time

smalldatetime

The time of the last update by Distribution Agent.

description

nvarchar(255)

The description of the subscription.

transaction_timestamp

varbinary(16)

Internal-use only.

update_mode

tinyint

The type of update.

agent_id

binary(16)

The ID of the agent.

subscription_guid

binary(16)

The global identifier for the version of the subscription on the publication.

subid

binary(16)

The global identifier for an anonymous subscription.

immediate_sync

bit

Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs.

Community Additions

ADD
Show:
© 2015 Microsoft