Tx learned 1 or 2 things & also did it wif a table variable and saw different results as well.

DECLARE@CategoryChanges TABLE

(

ChangeID int Primary Key Identity ,

CategoryID int ,

OldCategoryName nvarchar(15),

NewCategoryName nvarchar(15),

ModifiedDate datetime,

LoginID nvarchar(30)

);

BEGIN TRAN

INSERT@CategoryChanges

SELECT1, 'Cat1', 'Cat2', GETDATE(), SUSER_SNAME()

SELECT * FROM @CategoryChanges

ROLLBACK TRAN

SELECT * FROM @CategoryChanges