Performing Transactions
Microsoft® SQL Server™ and the SQL Server ODBC driver support the ODBC API transaction management functions. Microsoft offers full support for local transactions on an individual server. The SQL Server ODBC driver uses these features to support the ODBC API functions that manage transactions.
Through the use of the Microsoft Distributed Transaction Coordinator (MS DTC), the SQL Server ODBC driver can participate in distributed transactions spanning multiple servers.