Can You Nest Transactions in SQL Server? www.brentozar.com/archive/2023... It doesn't do what you think it does.
www.brentozar.com
To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE dbo.StatusLog (TimeItHappened DATETIME2 PRIMARY KEY CLUSTERED, Step VARCHAR(20)); GO And then…