Transact-SQL Reference

sp_helpsubscription_properties

Retrieves security information from the MSsubscription_properties table. This stored procedure is executed at the machine where the DTS package is stored.

Syntax

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

Arguments

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

Result Sets
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 = Snapshot
1 = Transactional
2 = Merge

publisher_login sysname Login ID used at the Publisher for SQL Server Authentication.
publisher_password sysname 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 sysname 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 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 sysname 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 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. If 0, the package location is at the Distributor. If 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.

Remarks

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

Permissions

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

See Also

System Stored Procedures