Displays information about a Subscriber.
sp_helpsubscriberinfo [[@subscriber =] 'subscriber']
Column name | Data type | Description |
---|---|---|
publisher | sysname | Name of the Publisher. |
subscriber | sysname | Name of the Subscriber. |
type | tinyint | Type of Subscriber: 0 = Microsoft SQL Server database 1 = ODBC data source |
login | sysname | Login ID for SQL Server Authentication. |
password | sysname | Password for SQL Server Authentication. |
commit_batch_size | int | Not supported. |
status_batch_size | int | Not supported. |
flush_frequency | int | Not supported. |
frequency_type | int | Frequency with which the Distribution Agent is run: 1 = One time 2 = On demand 4 = Daily 8 = Weekly 16 = Monthly 32 = Monthly relative 64 = Autostart 124 = Recurring |
frequency_interval | int | Value applied to the frequency set by frequency_type. |
frequency_relative_interval | int | Date of the Distribution Agent Used when frequency_type is set to 32 (monthly relative): 1 = First 2 = Second 4 = Third 8 = Fourth 16 = Last |
frequency_recurrence_factor | int | Recurrence factor used by frequency_type. |
frequency_subday | int | How often to reschedule during the defined period: 1 = Once 2 = Second 4 = Minute 8 = Hour |
frequency_subday_interval | int | Interval for frequency_subday. |
active_start_time_of_day | int | Time of day when the Distribution Agent is first scheduled, formatted as HHMMSS. |
active_end_time_of_day | int | Time of day when the Distribution Agent stops being scheduled, formatted as HHMMSS. |
active_start_date | int | Date when the Distribution Agent is first scheduled, formatted as YYYYMMDD. |
active_end_date | int | Date when the Distribution Agent stops being scheduled, formatted as YYYYMMDD. |
retryattempt | int | Not supported. |
retrydelay | int | Not supported. |
description | nvarchar(255) | Text description of the Subscriber. |
security_mode | int | Implemented security mode: 0 = SQL Server Authentication 1 = Windows NTAuthentication |
sp_helpsubscriberinfo is used in snapshot, transactional, and merge replication.
Only members of the sysadmin fixed server role can execute sp_helpsubscriberinfo.
sp_adddistpublisher | sp_dropsubscriber |
sp_addsubscriber | sp_helpdistributor |
sp_changesubscriber | sp_helpserver |
sp_dboption | System Stored Procedures |