sp_helpsubscription_properties (Transact-SQL)
Retrieves security information from the MSsubscription_properties table. This stored procedure is executed at the Subscriber.
Transact-SQL Syntax Conventions
- [ @publisher=] 'publisher'
-
Is the name of the Publisher. publisher is sysname, with a default of %, which returns information on all Publishers.
- [ @publisher_db=] 'publisher_db'
-
Is the name of the Publisher database. publisher_db is sysname, with a default of %, which returns information on all Publisher databases.
- [ @publication=] 'publication'
-
Is the name of the publication. publication is sysname, with a default of %, which returns information on all publications.
- [ @publication_type=] publication_type
-
Is the type of publication. publication_type is int, with a default of NULL. If supplied, publication_type must be one of the following values:
Value Description 0
Transactional publication
1
Snapshot publication
2
Merge publication
| 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 1 = Snapshot 2 = Merge |
|
publisher_login |
sysname |
Login ID used at the Publisher for SQL Server Authentication. |
|
publisher_password |
nvarchar(524) |
Password used at the Publisher for SQL Server Authentication (encrypted). |
|
publisher_security_mode |
int |
Security mode used at the Publisher: 0 = SQL Server Authentication 1 = Windows Authentication |
|
distributor |
sysname |
Name of the Distributor. |
|
distributor_login |
sysname |
Distributor login. |
|
distributor_password |
nvarchar(524) |
Distributor password (encrypted). |
|
distributor_security_mode |
int |
Security mode used at the Distributor: 0 = SQL Server Authentication 1 = Windows Authentication |
|
ftp_address |
sysname |
For backward compatibility only. Network address of the file transfer protocol (FTP) service for the Distributor. |
|
ftp_port |
int |
For backward compatibility only. Port number of the FTP service for the Distributor. |
|
ftp_login |
sysname |
For backward compatibility only. User name used to connect to the FTP service. |
|
ftp_password |
nvarchar(524) |
For backward compatibility only. 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 |
sysame |
Specifies the name of the Data Transformation Services (DTS) package. |
|
dts_package_password |
nvarchar(524) |
Specifies the password on the package, if there is one. |
|
dts_package_location |
int |
Location where the DTS package is stored. 0 = the package location is at the Distributor. 1 = the package location is at the Subscriber. |
|
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. |
|
use_web_sync |
bit |
Specifies if the subscription can be synchronized over HTTPS, where a value of 1 means that this feature is enabled. |
|
internet_url |
nvarchar(260) |
URL that represents the location of the replication listener for Web synchronization. |
|
internet_login |
nvarchar(128) |
Login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication. |
|
internet_password |
nvarchar(524) |
Password for the login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic 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 Basic Authentication. |
|
internet_timeout |
int |
Length of time, in seconds, before a Web synchronization request expires. |
|
hostname |
nvarchar(128) |
Specifies the value for HOST_NAME() when this function is used in the WHERE clause parameterized row filter. |
