download sql2005 sp2

which one i should download for my sql2005 server(win2003 server).
SQLServer2005SP2-KB921896-IA64-ENU.exe
SQLServer2005SP2-KB921896-x64-ENU.exe
SQLServer2005SP2-KB921896-x86-ENU.exe
The answer depends on your hardware platform.
IA64 is for Itanium
x64 is for the AMD and Intel 64-bit non-itanium platform.
x86 is the 32-bit version.
Select @.@.version will tell you what architecture you are running
For Example:
Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
That is an x64 system.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
> which one i should download for my sql2005 server(win2003 server).
> SQLServer2005SP2-KB921896-IA64-ENU.exe
> SQLServer2005SP2-KB921896-x64-ENU.exe
> SQLServer2005SP2-KB921896-x86-ENU.exe
>
|||How do I find out the machine is 32-bit or 64 version?
Thanks
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:utQ8reEtHHA.4800@.TK2MSFTNGP05.phx.gbl...
> The answer depends on your hardware platform.
> IA64 is for Itanium
> x64 is for the AMD and Intel 64-bit non-itanium platform.
> x86 is the 32-bit version.
> Select @.@.version will tell you what architecture you are running
> For Example:
> --
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
> Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> --
> That is an x64 system.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
>