sp_addpublication_snapshot |
Ajout d'une publication d'instantané |
|---|---|
| SQL Server | |
Syntaxe
|
sp_addpublication_snapshot [ @publication= ] 'publication' [ , [ @frequency_type= ] frequency_type ] [ , [ @frequency_interval= ] frequency_interval ] [ , [ @frequency_subday= ] frequency_subday ] [ , [ @frequency_subday_interval= ] frequency_subday_interval ] [ , [ @frequency_relative_interval= ] frequency_relative_interval ] [ , [ @frequency_recurrence_factor= ] frequency_recurrence_factor ] [ , [ @active_start_date= ] active_start_date ] [ , [ @active_end_date= ] active_end_date ] [ , [ @active_start_time_of_day= ] active_start_time_of_day ] [ , [ @active_end_time_of_day= ] active_end_time_of_day ] [ , [ @snapshot_job_name = ] 'snapshot_agent_name' ] [ , [ @publisher_security_mode = ] publisher_security_mode ] [ , [ @publisher_login = ] 'publisher_login' ] [ , [ @publisher_password = ] 'publisher_password' ] [ , [ @job_login = ] 'job_login' ] [ , [ @job_password = ] 'job_password' ] [ , [ @publisher = ] 'publisher' ] |
Description
Cette Stored Procedure permet de créer l'Agent de capture instantanée Snapshot Agent pour la publication spécifiée. 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