Greetings,
I wanted to find if I could do this:

Begin Trans A
--Code
Begin Trans B
--Code
Commit Trans B
--Code
Rollback Trans A

The problem was we had some nested transactions, and wanted to find out if we could Commit one transaction, and Rollback around it. Apparently there was a setting in a previous version of SQL that would allow this, according to one of our DBA's, but 7.0 doesn't have the same functionality. At this point, we believe it can't be done, but I wanted to get wider input before going around this.

TIA,
Brad