Execute Scripts Before and After a Snapshot Is Applied (SQL Server Management Studio)
Specify an optional script to execute before or after the snapshot is applied on the Snapshot page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see View and Modify Publication Properties.
[!UWAGA]
These options are not available if the Snapshot format option is set to Character.
To execute a script before or after a snapshot is applied
On the Snapshot page of the Publication Properties - <Publication> dialog box:
To specify a script to execute before the snapshot is applied, click Browse to navigate to the script, or enter a path to the script in the Before applying the snapshot, execute this script text box.
[!UWAGA]
The Distribution Agent or Merge Agent must have read permissions for the directory you specify. If pull subscriptions are used, you must specify a shared directory as a universal naming convention (UNC) path, such as \\computername\scripts\myscript.sql.
To specify a script to execute after the snapshot is applied, click Browse to navigate to the script, or enter a UNC path to the script in the After applying the snapshot, execute this script text box.
Click OK.
Zobacz także
Inne zasoby
Configure Snapshot Properties (Replication Transact-SQL Programming)
Change Publication and Article Properties