MSsubscription_properties (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSsubscription_properties (Transact-SQL)

 

Applies To: SQL Server

The MSsubscription_properties table contains rows for the parameter information required to run replication agents at the Subscriber. This table is stored in the subscription database at the Subscriber for a pull subscription or in the distribution database at the Distributor for a push subscription.

Column nameData typeDescription
publishersysnameThe name of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
publicationsysnameThe name of the publication.
publication_typeintThe type of publication:

 0 = Transactional.

 2 = Merge.
publisher_loginsysnameThe Login ID used at the Publisher for SQL Server Authentication.
publisher_passwordnvarchar(524)The password (encrypted) used at the Publisher for SQL Server Authentication.
publisher_security_modeintSecurity mode implemented at the Publisher:

 0 = Microsoft SQL Server Authentication.

 1 = Microsoft Windows Authentication.

 2 = The synchronization triggers use a static sysservers entry to do a remote procedure call (RPC), and publisher must be defined in the sysservers table as a remote server or linked server.
distributorsysnameThe name of the Distributor.
distributor_loginsysnameThe login ID used at the Distributor for SQL Server Authentication.
distributor_passwordnvarchar(524)The password (encrypted) used at the Distributor for SQL Server Authentication.
distributor_security_modeintThe security mode implemented at the Distributor:

 0 = SQL Server Authentication.

 1 = Windows Authentication.
ftp_addresssysnameThe network address of the file transfer protocol (FTP) service for the Distributor.
ftp_portintThe port number of the FTP service for the Distributor.
ftp_loginsysnameThe username used to connect to the FTP service.
ftp_passwordnvarchar(524)The u.User password used to connect to the FTP service.
alt_snapshot_foldernvarchar(255)Specifies the location of the alternate folder for the snapshot.
working_directorynvarchar(255)The name of the working directory used to store data and schema files.
use_ftpbitSpecifies the use of FTP instead of the regular protocol to retrieve snapshots. If 1, FTP is used.
dts_package_namesysnameSpecifies the name of the Data Transformation Services (DTS) package.
dts_package_passwordnvarchar(524)Specifies the password on the package.
dts_package_locationintThe location where the DTS package is stored.
enabled_for_syncmgrbitSpecifies whether the subscription can be synchronized through the Microsoft Synchronization Manager.

 0 = Subscription is not registered with Synchronization Manager.

 1 = Subscription is registered with Synchronization Manager and can be synchronized without starting SQL Server Management Studio.
offload_agentbitSpecifies whether the agent can be activated remotely or not. If 0, the agent cannot be activated remotely.
offload_serversysnameSpecifies the network name of the server used for remote activation.
dynamic_snapshot_locationnvarchar(255)Specifies the path to the folder where the snapshot files are saved.
use_web_syncbitSpecifies whether the subscription can be synchronized over HTTP or not. A value of 1 means that this feature is enabled.
internet_urlnvarchar(260)The URL that represents the location of the replication listener for Web synchronization.
internet_loginsysnameThe login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using SQL Server Authentication.
internet_passwordnvarchar(524)The password for the login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using SQL Server Authentication.
internet_security_modeintThe authentication mode used when connecting to the Web server that is hosting Web synchronization, where a value of 1 means Windows Authentication, and a value of 0 means SQL Server Authentication.
internet_timeoutintThe length of time, in seconds, before a Web synchronization request expires.
hostnamesysnameSpecifies the value for HOST_NAME when this function is used in the WHERE clause of a join filter or logical record relationship.

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

Community Additions

ADD
Show:
© 2016 Microsoft