CREATE TABLE #MyTable(<column name> <column Type> , etc)

INSERT #MyTable(<fields>
exec master.dbo.xp_msver

Thanks, Very useful to find the version and sp of sqlserver

Thanks, for the information provided. but it will be a great help if anyone could send a list of patches released and what patches are included in the service pack

Thanks In Advance

Gowtham