sp_changesubstatus |
Change l'état d'abonnement |
---|---|
SQL Server |
Syntaxe
sp_changesubstatus [ [ @publication = ] 'publication' ] [ , [ @article = ] 'article' ] [ , [ @subscriber = ] 'subscriber' ] , [ @status = ] 'status' [ , [ @previous_status = ] 'previous_status' ] [ , [ @destination_db = ] 'destination_db' ] [ , [ @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 ] [ , [ @optional_command_line = ] 'optional_command_line' ] [ , [ @distribution_jobid = ] distribution_jobid ] [ , [ @from_auto_sync = ] from_auto_sync ] [ , [ @ignore_distributor = ] ignore_distributor ] [ , [ @offloadagent= ] remote_agent_activation ] [ , [ @offloadserver= ] 'remote_agent_server_name' ] [ , [ @dts_package_name= ] 'dts_package_name' ] [ , [ @dts_package_password= ] 'dts_package_password' ] [ , [ @dts_package_location= ] dts_package_location ] [ , [ @skipobjectactivation = ] skipobjectactivation [ , [ @distribution_job_name= ] 'distribution_job_name' ] [ , [ @publisher = ] 'publisher' ] |
Description
Cette Stored Procedure permet de modifier l'état d'un Abonné existant. 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