Listing 2: Stored Procedure That Prevents Sequence Table from Growing

CREATE PROC usp_newseq2 @v AS INT OUTPUT 
AS
BEGIN TRAN;
SAVE TRAN S;
INSERT INTO Seq2 DEFAULT VALUES;
SET @v = SCOPE_IDENTITY();
ROLLBACK TRAN S;
COMMIT TRAN;