Page 1 of 1

Multiple Transactions ...

Posted: Tue 12 Jun 2007 18:20
by HK
How to enable Multiple Transactions for Sql Server 2005? We need enable it for use the transactions IDs.

The MultipleTransactionsSupport always ruturns False ...


Thanks

Posted: Wed 13 Jun 2007 08:14
by Jackson
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.