SQL Server doesn't really support nested transactions - in a sense. You can nest calls to BEGIN TRANSACTION and you must submit a COMMIT for each level. The problem is that a ROLLBACK terminates all transactions, no matter how deep the nesting.

-Mike