--- title: "MSsubscription_properties (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/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: - "MSsubscription_properties" - "MSsubscription_properties_TSQL" dev_langs: - "TSQL" helpviewer_keywords: - "MSsubscription_properties system table" ms.assetid: f96fc1ae-b798-4b05-82a7-564ae6ef23b8 caps.latest.revision: 29 author: "BYHAM" ms.author: "rickbyh" manager: "jhubbard" --- # MSsubscription_properties (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)] 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 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.| |**publication_type**|**int**|The type of publication:

**0** = Transactional.

**2** = Merge.| |**publisher_login**|**sysname**|The Login ID used at the Publisher for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**publisher_password**|**nvarchar(524)**|The password (encrypted) used at the Publisher for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**publisher_security_mode**|**int**|Security mode implemented at the Publisher:

**0** = [!INCLUDE[msCoName](../../includes/msconame-md.md)] SQL Server Authentication.

**1** = [!INCLUDE[msCoName](../../includes/msconame-md.md)] 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.| |**distributor**|**sysname**|The name of the Distributor.| |**distributor_login**|**sysname**|The login ID used at the Distributor for SQL Server Authentication.| |**distributor_password**|**nvarchar(524)**|The password (encrypted) used at the Distributor for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**distributor_security_mode**|**int**|The security mode implemented at the Distributor:

**0** = [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.

**1** = Windows Authentication.| |**ftp_address**|**sysname**|The network address of the file transfer protocol (FTP) service for the Distributor.| |**ftp_port**|**int**|The port number of the FTP service for the Distributor.| |**ftp_login**|**sysname**|The username used to connect to the FTP service.| |**ftp_password**|**nvarchar(524)**|The u.User password used to connect to the FTP service.| |**alt_snapshot_folder**|**nvarchar(255)**|Specifies the location of the alternate folder for the snapshot.| |**working_directory**|**nvarchar(255)**|The name of the working directory used to store data and schema files.| |**use_ftp**|**bit**|Specifies the use of FTP instead of the regular protocol to retrieve snapshots. If **1**, FTP is used.| |**dts_package_name**|**sysname**|Specifies the name of the Data Transformation Services (DTS) package.| |**dts_package_password**|**nvarchar(524)**|Specifies the password on the package.| |**dts_package_location**|**int**|The location where the DTS package is stored.| |**enabled_for_syncmgr**|**bit**|Specifies whether the subscription can be synchronized through the [!INCLUDE[msCoName](../../includes/msconame-md.md)] Synchronization Manager.

**0** = Subscription is not registered with Synchronization Manager.

**1** = Subscription is registered with Synchronization Manager and can be synchronized without starting [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)].| |**offload_agent**|**bit**|Specifies whether the agent can be activated remotely or not. If **0**, the agent cannot be activated remotely.| |**offload_server**|**sysname**|Specifies the network name of the server used for remote activation.| |**dynamic_snapshot_location**|**nvarchar(255)**|Specifies the path to the folder where the snapshot files are saved.| |**use_web_sync**|**bit**|Specifies whether the subscription can be synchronized over HTTP or not. A value of **1** means that this feature is enabled.| |**internet_url**|**nvarchar(260)**|The URL that represents the location of the replication listener for Web synchronization.| |**internet_login**|**sysname**|The login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**internet_password**|**nvarchar(524)**|The password for the login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**internet_security_mode**|**int**|The 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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.| |**internet_timeout**|**int**|The length of time, in seconds, before a Web synchronization request expires.| |**hostname**|**sysname**|Specifies the value for **HOST_NAME** when this function is used in the **WHERE** clause of a join filter or logical record relationship.| ## See Also [Replication Tables (Transact-SQL)](../../relational-databases/system-tables/replication-tables-transact-sql.md) [Replication Views (Transact-SQL)](../../relational-databases/system-views/replication-views-transact-sql.md) [sp_helppullsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helppullsubscription-transact-sql.md) [sp_helpsubscription (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpsubscription-transact-sql.md) [sp_helpsubscription_properties (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-helpsubscription-properties-transact-sql.md)