Is there any way that I can customize the triggers created by SyncFramework? I want to add the statement as 'SET NOCOUNT ON' in each of the triggers created by Sync Framework.
afaik, there's none in the API that allows you to insert arbitrary statements in the provisioning. you can try SqlSyncScopeProvisioning.Script to generate the script, then modify and run the script afterwards.
Proposed as answer byGaneshanFriday, July 23, 2010 4:25 PM