TransactionScope with SQL Server 2000

  • Thread starter Thread starter Néstor Sánchez A.
  • Start date Start date
N

Néstor Sánchez A.

Hi,

Can I use TransactionScope with SQL Server 2000 without DTC?
If no.... what is the simplest way (example please) to manage transactions
with 2000?
Thanks in advance.


Néstor.
 
Néstor Sánchez A. said:
Hi,

Can I use TransactionScope with SQL Server 2000 without DTC?
If no.... what is the simplest way (example please) to manage transactions
with 2000?
Thanks in advance.
Click to expand...


Here's an approach:

Fast transactions with System.Transactions and Microsoft SQL Server 2000
http://blogs.msdn.com/florinlazar/archive/2005/09/29/475546.aspx


Writing a resource manager that supports promotable transactions (or
Promotable Single Phase Enlistment aka PSPE) in System.Transactions
http://blogs.msdn.com/florinlazar/archive/2005/05/17/418595.aspx

David
 
Back
Top