execute-scripts-during-synchronization-replication-transact-sql-programming.md

title	Execute Scripts During Synchronization (Replication Transact-SQL Programming) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	article
dev_langs	TSQL
helpviewer_keywords	synchronization [SQL Server replication], scripts scripts [SQL Server replication], synchronization and sp_addscriptexec
ms.assetid	b58a0877-4e43-4fab-a281-24e6022d3fb1
caps.latest.revision	34
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Execute Scripts During Synchronization (Replication Transact-SQL Programming)

Replication supports on demand script execution for Subscribers to transactional and merge publications. This functionality copies the script to the replication working directory and then uses sqlcmd to apply the script at the Subscriber. By default, if there is a failure when applying the script for a subscription to a transactional publication, the Distribution Agent will stop. You can specify a [!INCLUDEtsql] script to execute programmatically using replication stored procedures.

To specify a script to run for all Subscribers to a snapshot, transactional or merge publication

1. Compose and test the [!INCLUDEtsql] script that will be executed on demand.

2. Save the script file to a location where it can be accessed by the Snapshot Agent for the publication.

3. At the Publisher on the publication database, execute sp_addscriptexec (Transact-SQL). Specify @publication, the name of the script file with full UNC path created in step 2 for @scriptfile, and one of the following values for @skiperror:

   • 0 - the agent will stop executing the script if an error is encountered.

   • 1 - the agent will log errors and continue executing the script when errors are encountered.

4. The specified script will be executed at each Subscriber when the agent next runs to synchronize the subscription.

See Also

Synchronize Data