Retrieves security information from the MSsubscription_properties table.
sp_helpsubscription_properties [[@publisher =] 'publisher']
[,[@publisher_db =] 'publisher_db'] [,[@publication =] 'publication']
[,[@publication_type =] publication_type]
| 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. |
| publisher_security_mode | int | Security mode used at the Publisher: 0 = SQL Server Authentication 1 = Windows NT Authentication |
| encrypted_publisher_password | bit | Indicates whether password is encrypted. |
| distributor_login | sysname | Distributor login. |
| distributor_password | sysname | Distributor password. |
| distributor_security_mode | int | Security mode used at the Distributor: 0 = SQL Server Authentication 1 = Windows NT Authentication |
| encrypted_distributor_password | bit | For internal use only. |
| 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. |
sp_helpsubscription_properties is used in snapshot, transactional, and merge replication.
Only members of the sysadmin fixed server role can execute sp_helpsubscription_properties.
| System Stored Procedures |