Is this what you are describing? Code: CREATE TABLE myTable99(Col1 int PRIMARY KEY, Col2 char(1), Col3 datetime) GO CREATE PROC Sproc1 AS BEGIN
TRAN INSERT INTO myTable99(Col1) SELECT 1 COMMIT TRAN GO CREATE PROC Sproc2 AS BEGIN TRAN INSERT INTO myTable99(Col1, Col2) SELECT 2, 'b' COMMIT TRAN GO CREATE PROC Sproc3 AS BEGIN TRAN INSERT INTO myTable99(...