sp_helpsubscriberinfo (Transact-SQL)

Displays information about a Subscriber. This stored procedure is executed at the Publisher on any database.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_helpsubscriberinfo [ [ @subscriber =] 'subscriber']
    [ , [ @publisher = ] 'publisher' ]

Arguments

  • [ @subscriber = ] 'subscriber'
    Is the name of the Subscriber. subscriber is sysname, with a default of %, which returns all information.
  • [ @publisher = ] 'publisher'
    Is the name of the Publisher. publisher is sysname, and defaults to the name of the current server.

    Note

    publisher should not be specified, except when it is an Oracle Publisher.

Return Code Values

0 (success) or 1 (failure)

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

128 = 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 = Microsoft Windows Authentication

frequency_type2

int

Frequency with which the Merge Agent is run:

1 = One time

2 = On demand

4 = Daily

8 = Weekly

16 = Monthly

32 = Monthly relative

64 = Autostart

128 = Recurring

frequency_interval2

int

Value applied to the frequency set by frequency_type.

frequency_relative_interval2

int

Date of the Merge Agent used when frequency_type is set to 32(monthly relative):

1 = First

2 = Second

4 = Third

8 = Fourth

16 = Last

frequency_recurrence_factor2

int

Recurrence factor used by frequency_type.

frequency_subday2

int

How often to reschedule during the defined period:

1 = Once

2 = Second

4 = Minute

8 = Hour

frequency_subday_interval2

int

Interval for frequency_subday.

active_start_time_of_day2

int

Time of day when the Merge Agent is first scheduled, formatted as HHMMSS.

active_end_time_of_day2

int

Time of day when the Merge Agent stops being scheduled, formatted as HHMMSS.

active_start_date2

int

Date when the Merge Agent is first scheduled, formatted as YYYYMMDD.

active_end_date2

int

Date when the Merge Agent stops being scheduled, formatted as YYYYMMDD.

Remarks

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

Permissions

Only members of the sysadmin fixed server role, the db_owner fixed database role, or the publication access list for the publication can execute sp_helpsubscriberinfo.

See Also

Reference

sp_adddistpublisher (Transact-SQL)
sp_addpullsubscription (Transact-SQL)
sp_changesubscriber (Transact-SQL)
sp_dboption (Transact-SQL)
sp_dropsubscriber (Transact-SQL)
sp_helpdistributor (Transact-SQL)
sp_helpserver (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance