sp_addmergesubscription |
Ajout de fusion d'abonnement |
---|---|
SQL Server |
Syntaxe
sp_addmergesubscription [ @publication= ] 'publication' [ , [ @subscriber = ] 'subscriber' ] [ , [ @subscriber_db= ] 'subscriber_db' ] [ , [ @subscription_type= ] 'subscription_type' ] [ , [ @subscriber_type= ] 'subscriber_type' ] [ , [ @subscription_priority= ] subscription_priority ] [ , [ @sync_type= ] 'sync_type' ] [ , [ @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' ] [ , [ @description= ] 'description' ] [ , [ @enabled_for_syncmgr= ] 'enabled_for_syncmgr' ] [ , [ @offloadagent= ] remote_agent_activation] [ , [ @offloadserver= ] 'remote_agent_server_name' ] [ , [ @use_interactive_resolver= ] 'use_interactive_resolver' ] [ , [ @merge_job_name= ] 'merge_job_name' ] [ , [ @hostname = ] 'hostname' |
Description
Cette Stored Procedure permet de créer un abonnement de fusion push ou pull. 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