> SQL Server is one of the few commercial DB's that does real nested transactions

Not sure where this myth keeps coming from, but no, it does not:

https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a...