sp_changesubscriber |
Change l'abonnement |
|---|---|
| SQL Server | |
Syntaxe
|
sp_changesubscriber [ @subscriber= ] 'subscriber' [ , [ @type= ] type ] [ , [ @login= ] 'login' ] [ , [ @password= ] 'password' ] [ , [ @commit_batch_size= ] commit_batch_size ] [ , [ @status_batch_size= ] status_batch_size ] [ , [ @flush_frequency= ] flush_frequency ] [ , [ @frequency_type= ] frequency_type ] [ , [ @frequency_interval= ] frequency_interval ] [ , [ @frequency_relative_interval= ] frequency_relative_interval ] [ , [ @frequency_recurrence_factor= ] frequency_recurrence_factor ] [ , [ @frequency_subday= ] frequency_subday ] [ , [ @frequency_subday_interval= ] frequency_subday_interval ] [ , [ @active_start_time_of_day= ] active_start_time_of_day ] [ , [ @active_end_time_of_day= ] active_end_time_of_day ] [ , [ @active_start_date= ] active_start_date ] [ , [ @active_end_date= ] active_end_date ] [ , [ @description= ] 'description' ] [ , [ @security_mode= ] security_mode ] [ , [ @publisher = ] 'publisher' ] |
Description
Cette Stored Procedure permet de modifier les options d'un Subscriber. Toute tâche de distribution pour les Subscribers à cet Publisher est mise à jour. Cette STORED PROCEDURE écrit dans la table MSsubscriber_info dans la base de données de distribution. Cette STORED PROCEDURE est exécutée au niveau du Publisher sur la base de données de publication.
Dernière mise à jour : Dimanche, le 29 Août 2021