>Howdy (Texas talk for "Hi All")
>
>I have a situation where I would like to surround some multi-table transactions with BEGIN TRANSACTION/END TRANSACTION and rollback to the previous table states if the entire series of multiple transactions is not successful.
>
>Since this will require the opening and closing of many, many tables in at two differnt sites, and the creation and destruction of multiple cursor, I am wondering if it is even practical.
>
>Any thoughts or advice would be appreciated.
>
>TIA
You won't be able to do it with one transaction. All the tables must be in the same DBC.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer