I need to set up a transaction that will span multiple pages. I want to start the transaction at the first page and then when someone finishes the process by making a payment I can commit the transaction. If the quit by closing the browser I want to rollback the order. I am using SQL server 2000 and ASP. I tried using BEGIN TRANSACTION and END TRANSACTION. But that only seems to work during a single connection. Is there a global begin transaction or something. I have looked a little into MTS but it seems to work only within a single connection as well. If I skip from page to page opening and closing connections I loose the ablility to start and end transactions. Any suggestions?