is my SQL2000 32-bit or 64-bit?

Hi, how can I tell if my SQL2000 server is 32-bit or 64-
bit? I am trying to install the latest security patch and
I noticed that there are two different versions (one for
32-bit and one for 64-bit). thanks
christos
ps. I am running SQL2000 SP3 on Win2k ServerChristos,
You should be able to tell by running a SELECT @.@.version against your SQL
Server.
On 32-bit, you will see the following:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
......
On 64-bit, the architecture should be Intel IA-64
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64)
......
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Christos Kritikos" <christos@.alphadetail.com> wrote in message
news:036901c35617$3a1691a0$a601280a@.phx.gbl...
> Hi, how can I tell if my SQL2000 server is 32-bit or 64-
> bit? I am trying to install the latest security patch and
> I noticed that there are two different versions (one for
> 32-bit and one for 64-bit). thanks
> christos
> ps. I am running SQL2000 SP3 on Win2k Server|||When you run SELECT @.@.VERSION, there will be a string like Intel IA-64 in
the result for 64-bit hardware.
And as Vyas points out, you'd probably remember buying 64-bit hardware (or
just ask your finance department). :-)
"Christos Kritikos" <christos@.alphadetail.com> wrote in message
news:036901c35617$3a1691a0$a601280a@.phx.gbl...
> Hi, how can I tell if my SQL2000 server is 32-bit or 64-
> bit? I am trying to install the latest security patch and
> I noticed that there are two different versions (one for
> 32-bit and one for 64-bit). thanks
> christos
> ps. I am running SQL2000 SP3 on Win2k Server