Multiple Transactions ...

HK · Post by HK » Tue 12 Jun 2007 18:20

How to enable Multiple Transactions for Sql Server 2005? We need enable it for use the transactions IDs.

The MultipleTransactionsSupport always ruturns False ...

Thanks

Jackson · Post by **Jackson** » Wed 13 Jun 2007 08:14

SQL Server doesn't support overlapped transactions.
Nested transactions are not supported by OLE DB providers for SQL Server.
So you can use only a single transaction at a time using DbxSda.