Find Server Information on SQL Server 2008

exec xp_msver "ProductName", "ProductVersion", "Language", "Platform",
"WindowsVersion", "PhysicalMemory", "ProcessorCount"

Microsoft certified technology specialist

MCTS in SQL Server 2008