Export (0) Print
Expand All
Expand Minimize

How to: 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 How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

ms152549.note(en-US,SQL.90).gifNote:
These options are not available if the Snapshot format option is set to Character.

  1. 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.
      ms152549.note(en-US,SQL.90).gifNote:
      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.
  2. Click OK.

Community Additions

ADD
Show:
© 2014 Microsoft