By default, the SQL Server Native Client OLE DB provider uses an autocommit transaction mode, where each discrete action on a consumer session comprises a complete transaction against an instance of SQL Server. The SQL Server Native Client OLE DB provider autocommit mode is local, and autocommit transactions never span more than a single session.

The SQL Server Native Client OLE DB provider exposes the ITransactionLocal interface, allowing the consumer to use explicitly and implicitly start transactions on a single connection to an instance of SQL Server. The SQL Server Native Client OLE DB provider does not support nested local transactions.