I was tooling around Microsoft SQL server in preparation for a 64 bit migration when I came across this interesting command.
xp_msver
It returned the following for my Intel box.
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 589824 9.00.4035.00
3 Language 1033 English (United States)
4 Platform NULL NT AMD64
5 Comments NULL NT AMD64
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT – 64 Bit
8 FileVersion NULL 2005.090.4035.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 264437760 NULL
15 WindowsVersion 248381957 5.2 (3790)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 1
18 ProcessorType 8664 NULL
19 PhysicalMemory 7935 7935 (8320720896)
20 Product ID NULL NULL
Interesting to see that it reports an AMD CPU. Checking with Google, it appears that AMD beat Intel to the 64 bit arena, as such got frozen in programming history. link
Update 19 Apr 11
I was wondering if any of my dark servers can take a 64 bit OS. This very nifty tool from VMware does a width check. Link
Update 24 Jul 11
The SQL version numbers reported above are not friendly to non-SQL gurus. This command helps a bit.
Select @@version
Microsoft SQL Server 2005 – 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)