Export (0) Print
Expand All
Expand Minimize

MSsubscription_properties

SQL Server 2000

The MSsubscription_properties table contains rows for the parameter information for pull Distribution Agents. This table is stored in the subscription database.

Column name Data type Description
publisher sysname Name of the Publisher.
publisher_db sysname Name of the Publisher database.
publication sysname Name of the publication.
publication_type int Type of publication:

0 = Transactional
2 = Merge

publisher_login sysname Login ID used at the Publisher for SQL Server Authentication.
publisher_password sysname Password (encrypted) used at the Publisher for SQL Server Authentication.
publisher_security_mode int Security mode implemented at the Publisher:

0 = SQL Server Authentication
1 = Windows Authentication
2 = The synchronization triggers use a static sysservers entry to do RPC, and publisher must be defined in the sysservers table as a remote server or linked server.

distributor sysname Name of the Distributor.
distributor_login sysname Login ID used at the Distributor for SQL Server Authentication.
distributor_password sysname Password (encrypted) used at the Distributor for SQL Server Authentication.
distributor_security_mode int Security mode implemented at the Distributor:

0 = SQL Server Authentication
1 = Windows Authentication

ftp_address sysname Network address of the FTP service for the Distributor.
ftp_port int Port number of the FTP service for the Distributor.
ftp_login sysname Username used to connect to the FTP service.
ftp_password sysname 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) 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 DTS package.
dts_package_password nvarchar(524) Specifies the password on the package, if there is one. A value of NULL means that the package has no password.
dts_package_location int Location where the DTS package is stored.
enabled_for_syncmgr bit Specifies whether the subscription can be synchronized through the Microsoft Synchronization Manager. If 0, subscription is not registered with Synchronization Manager. If 1, subscription is registered with Synchronization Manager and can be synchronized without starting SQL Server Enterprise Manager.
offload_agent bit Specifies if the agent can be activated remotely. 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.

Show:
© 2014 Microsoft