new patch for 32 bit and 64 bit SQL server

How do you determine if a server is running the 32 bit or
64 bit version. I have seen the query to determine service
pack level but I don't see an indicator to determine if a
server is 32 bit or 64 bit. There is a different patch
dependant on this value.>--Original Message--
>Pat,
>Is it the season? lol :-)
>I just answered a similar query a while back...
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Pat" <mcilweep@.ctbsonline.com> wrote in message
>news:01ee01c352d6$7d4ca5c0$a301280a@.phx.gbl...
>> How do you determine if a server is running the 32 bit
or
>> 64 bit version. I have seen the query to determine
service
>> pack level but I don't see an indicator to determine if
a
>> server is 32 bit or 64 bit. There is a different patch
>> dependant on this value.
>
>.
>I appreciate your reply but still don't see the info I
need. I found the info about determining the SP of SQL on
your website FAQ's, but I don't see anything that
indicates that it is a 32 bit or 64 bit system. What am I
missing?|||Pat,
May be I got carried away because I answered couple of similar posts
one-by-one in .server :-) The latest one was by Aparna Rege.Anyways, this is
the info:
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
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
On 64-bit, the architecture should be Intel IA-64
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64)
Thanks to : Arvind Krishnan
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Pat" <mcilweep@.ctbsonline.com> wrote in message
news:03cb01c352e6$10f67990$a101280a@.phx.gbl...
> >--Original Message--
> >Pat,
> >
> >Is it the season? lol :-)
> >
> >I just answered a similar query a while back...
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Pat" <mcilweep@.ctbsonline.com> wrote in message
> >news:01ee01c352d6$7d4ca5c0$a301280a@.phx.gbl...
> >> How do you determine if a server is running the 32 bit
> or
> >> 64 bit version. I have seen the query to determine
> service
> >> pack level but I don't see an indicator to determine if
> a
> >> server is 32 bit or 64 bit. There is a different patch
> >> dependant on this value.
> >
> >
> >.
> >I appreciate your reply but still don't see the info I
> need. I found the info about determining the SP of SQL on
> your website FAQ's, but I don't see anything that
> indicates that it is a 32 bit or 64 bit system. What am I
> missing?