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

sp_helpsubscription_properties (Transact-SQL)

 

Applies To: SQL Server

Retrieves security information from the MSsubscription_properties table. This stored procedure is executed at the Subscriber.

Topic link icon Transact-SQL Syntax Conventions

  
sp_helpsubscription_properties [ [ @publisher = ] 'publisher' ]  
    [ , [ @publisher_db =] 'publisher_db' ]   
    [ , [ @publication =] 'publication' ]  
    [ , [ @publication_type = ] publication_type ]   

[ @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:

ValueDescription
0Transactional publication
1Snapshot publication
2Merge publication
Column nameData typeDescription
publishersysnameName of the Publisher.
publisher_dbsysnameName of the Publisher database.
publicationsysnameName of the publication.
publication_typeintType of publication:

 0 = Transactional

 1 = Snapshot

 2 = Merge
publisher_loginsysnameLogin ID used at the Publisher for SQL Server Authentication.
publisher_passwordnvarchar(524)Password used at the Publisher for SQL Server Authentication (encrypted).
publisher_security_modeintSecurity mode used at the Publisher:

 0 = SQL Server Authentication

 1 = Windows Authentication
distributorsysnameName of the Distributor.
distributor_loginsysnameDistributor login.
distributor_passwordnvarchar(524)Distributor password (encrypted).
distributor_security_modeintSecurity mode used at the Distributor:

 0 = SQL Server Authentication

 1 = Windows Authentication
ftp_addresssysnameFor backward compatibility only. Network address of the file transfer protocol (FTP) service for the Distributor.
ftp_portintFor backward compatibility only. Port number of the FTP service for the Distributor.
ftp_loginsysnameFor backward compatibility only. User name used to connect to the FTP service.
ftp_passwordnvarchar(524)For backward compatibility only. 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)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_namesysameSpecifies the name of the Data Transformation Services (DTS) package.
dts_package_passwordnvarchar(524)Specifies the password on the package, if there is one.
dts_package_locationintLocation where the DTS package is stored.

 0 = the package location is at the Distributor.

 1 = the package location is at the Subscriber.
offload_agentbitSpecifies if the agent can be activated remotely. 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 if the subscription can be synchronized over HTTPS, where a value of 1 means that this feature is enabled.
internet_urlnvarchar(260)URL that represents the location of the replication listener for Web synchronization.
internet_loginnvarchar(128)Login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.
internet_passwordnvarchar(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_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 Basic Authentication.
internet_timeoutintLength of time, in seconds, before a Web synchronization request expires.
hostnamenvarchar(128)Specifies the value for HOST_NAME() when this function is used in the WHERE clause parameterized row filter.

0 (success) or 1 (failure)

sp_helpsubscription_properties is used in snapshot replication, transactional replication, and merge replication.

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_helpsubscription_properties.

System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft