[font="Verdana"]
...If I was to open a TRAN within a ADO connection, and then call a Sproc within the TRAN that has its own TRAN server-side, if the Sproc's TRAN fails, does the ADO TRAN also get rolled back?...
No. Because the failed Transaction is another transaction which is started inside the SProc. If it fails, it will Rollback only those changes taken place inside the SProc where the Transaction get started.
Mahesh[/font]
MH-09-AM-8694