sp_addsubscriber (version 6.5)

Adds a new subscriber server. An optional description parameter has been added and is used as a description for ODBC and SQL Server subscribers to determine what version of Microsoft SQL Server is being used for replication.

For additional syntax information for sp_addsubscriber, see the Microsoft SQL Server Transact-SQL Reference.

Syntax

sp_addsubscriber subscriber [, type] [, login] [, password] [, commit_batch_size]
[, status_batch_size] [, flush_frequency] [, frequency_type] [, frequency_interval]
[, frequency_relative_interval] [, frequency_recurrence_factor]
[, frequency_subday] [, frequency_subday_interval] [, active_start_time_of_day]
[, active_end_time_of_day] [, active_start_date] [, active_end_date]
[, description]

where

description

Specifies an optional text description. When upgrading to SQL Server 6.5, existing MSsubscriber_info tables are modified to include a description column, which is initialized to SQL Server 6.0. The description parameter can have a maximum of 255 characters and must have a varchar datatype.

Example

This example sets up ACCOUNTS as a subscription server and includes a comment as a description.

sp_addsubscriber ACCOUNTS, @description = 'Temporary Subscriber'
  

Permission

Execute permission defaults to the system administrator.