I have been using

select *from table_name in SSMS 2005, since 2 years & it works fine.

Please try once.

Jinesh.

Thanks a lot.:-)

Hi,

When I tried

DECLARE @Table TABLE

(

Matrix_User_ID INT --PRIMARY KEY IDENTITY(1,1)

,OldFirst_Name VARCHAR(20)

,NewFirst_Name VARCHAR(20)

)

BEGIN TRAN

UPDATE MSTR_User

SET First_Name=UPPER(First_Name)

OUTPUT inserted.Matrix_User_ID,deleted.First_name,inserted.First_name INTO @Table

WHERE Matrix_User_Id =1294

SELECT * FROM @Table

ROLLBACK TRAN

SELECT * FROM @Table

It returned row after...