sp_addsubscriber |
Ajout d'un abonnement |
|---|---|
| SQL Server | |
Syntaxe
|
sp_addsubscriber [ @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 ] [ , [ @encrypted_password = ] encrypted_password ] [ , [ @publisher = ] 'publisher' ] |
Description
Cette Stored Procedure permet d'ajouter un nouvel abonné à un Publisher, lui permettant de recevoir des publications. Cette STORED PROCEDURE est exécutée au niveau du serveur de publication sur la base de données de publication pour les publications instantanées et transactionnelles ; et pour les publications de fusion utilisant un Distributor à distance, cette STORED PROCEDURE est exécutée au niveau du Distributor.
Dernière mise à jour : Dimanche, le 29 Août 2021