sp_helpsubscriberinfo (T-SQL)

Displays information about a Subscriber.

Syntax

sp_helpsubscriberinfo [[@subscriber =] 'subscriber']

Arguments
[@subscriber =] 'subscriber'
Is the name of the Subscriber. subscriber is sysname, with a default of %, which returns all information.
Result Sets
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

Remarks

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

Permissions

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

See Also
sp_adddistpublisher sp_dropsubscriber
sp_addsubscriber sp_helpdistributor
sp_changesubscriber sp_helpserver
sp_dboption System Stored Procedures

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.