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.
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
This example sets up ACCOUNTS as a subscription server and includes a comment as a description.
sp_addsubscriber ACCOUNTS, @description = 'Temporary Subscriber'
Execute permission defaults to the system administrator.