Home All Groups Group Topic Archive Search About

TransactionScope with SQL Server 2000

Author
19 Oct 2006 4:36 PM
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.

Author
19 Oct 2006 4:42 PM
David Browne
"Néstor Sánchez A." <nestor.sanc***@akzio.cl> wrote in message
news:eKH$xy58GHA.2120@TK2MSFTNGP03.phx.gbl...
> 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.


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

AddThis Social Bookmark Button