sp_changesubscriber (version 6.5)

Changes the options for a subscription server. Any distribution task for the publisher's subscribers will be updated. The description parameter allows the user to add descriptive text and is used for ODBC and SQL Server subscribers to determine what version of SQL Server is being used for replication.

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

Syntax

sp_changesubscriber 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 that 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 puts in a comment as a description.

sp_changesubscriber ACCOUNTS, @description = 'Temporary Subscriber'
  

Permission

Execute permission defaults to the system administrator.