Only keeping the T-SQL scripts inside the Begin Transaction and Commit Transaction code doesn’t ensure that you have implemented the transaction. Consider the following two tables   CREATE TABLE dbo.SimpleOrders( orderid int IDENTITY(1,1) NOT NULL PRIMARY KEY, custid int NOT NULL , empid int NOT NULL , orderdate datetime NOT NULL ); GO   CREATE TABLE […]