SqlSyncScopeProvisioning.SetUseBulkProceduresDefault Method

Sets a value that indicates whether bulk procedures should be created when provisioning stored procedures. The default setting is true when provisioning a SQL Server 2008 or SQL Azure database; otherwise, it is false.

Namespace:  Microsoft.Synchronization.Data.SqlServer
Assembly:  Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)


Public Sub SetUseBulkProceduresDefault ( _
    useBulk As Boolean _
Dim instance As SqlSyncScopeProvisioning
Dim useBulk As Boolean

public void SetUseBulkProceduresDefault(
    bool useBulk
void SetUseBulkProceduresDefault(
    bool useBulk
member SetUseBulkProceduresDefault : 
        useBulk:bool -> unit 
public function SetUseBulkProceduresDefault(
    useBulk : boolean


  • useBulk
    Type: System.Boolean
    true if bulk procedures should be provisioned; otherwise false.


Bulk procedures take advantage of the table-valued parameter feature of SQL Server 2008 and SQL Azure to apply multiple inserts, updates, and deletes by using a single stored procedure call, instead of requiring a stored procedure call to apply each change. This greatly increases performance of these operations and reduces the number of trips between client and server during change application.

Be aware that after bulk procedures are created for a table, they are always used for all scopes that include the table, even scopes that specified that bulk procedures should not be used. Also, if a table has already been provisioned for another scope that uses bulk procedures, specifying false to SetUseBulkProceduresDefault has no effect.

See Also


SqlSyncScopeProvisioning Class

Microsoft.Synchronization.Data.SqlServer Namespace