How to find which version of SQL 2005 (32bit vs. 64bit)

I have found a kb on getting the Version/Build/ServicePack of SQL2005,
but how do you determine if you are running 32bit or 64 bit edition?
Thank you,
Mike
Seems xp_msver returns a platform property that for my machine say 'NT Intel X86'.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M Craig" <mcraig88@.newsgroups.nospam> wrote in message
news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>I have found a kb on getting the Version/Build/ServicePack of SQL2005, but how do you determine if
>you are running 32bit or 64 bit edition?
> Thank you,
> Mike
|||"M Craig" <mcraig88@.newsgroups.nospam> wrote in message
news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
>how do you determine if you are running 32bit or 64 bit edition?
> Thank you,
> Mike
SELECT @.@.VERSION -- 32 bit box
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
SELECT @.@.VERSION -- 64 bit box
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)
One is (Intel X86), the other (X64), also the Edition section shows
(64-bit) on the big box.
Rick Sawtell
|||Rick Sawtell wrote:
> "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>
> SELECT @.@.VERSION -- 32 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
>
> SELECT @.@.VERSION -- 64 bit box
> 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)
>
> One is (Intel X86), the other (X64), also the Edition section shows
> (64-bit) on the big box.
>
> Rick Sawtell
>
>
Thank you I'll try that.
|||Rick Sawtell wrote:
> "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>
> SELECT @.@.VERSION -- 32 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
>
> SELECT @.@.VERSION -- 64 bit box
> 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)
>
> One is (Intel X86), the other (X64), also the Edition section shows
> (64-bit) on the big box.
>
> Rick Sawtell
>
>
Thank you I'll try that.
|||It is Help Full,
jat,
http://www.earthsketch.com/seopage.html
M Craig wrote:
> Rick Sawtell wrote:
> Thank you I'll try that.

How to find which version of SQL 2005 (32bit vs. 64bit)

I have found a kb on getting the Version/Build/ServicePack of SQL2005,
but how do you determine if you are running 32bit or 64 bit edition?
Thank you,
MikeSeems xp_msver returns a platform property that for my machine say 'NT Intel
X86'.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"M Craig" <mcraig88@.newsgroups.nospam> wrote in message
news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
how do you determine if
>you are running 32bit or 64 bit edition?
> Thank you,
> Mike|||"M Craig" <mcraig88@.newsgroups.nospam> wrote in message
news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>I have found a kb on getting the Version/Build/ServicePack of SQL2005, but
>how do you determine if you are running 32bit or 64 bit edition?
> Thank you,
> Mike
SELECT @.@.VERSION -- 32 bit box
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
SELECT @.@.VERSION -- 64 bit box
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)
One is (Intel X86), the other (X64), also the Edition section shows
(64-bit) on the big box.
Rick Sawtell|||Rick Sawtell wrote:
> "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>
> SELECT @.@.VERSION -- 32 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:2
5
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Window
s
> NT 5.1 (Build 2600: Service Pack 2)
>
> SELECT @.@.VERSION -- 64 bit box
> 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)
>
> One is (Intel X86), the other (X64), also the Edition section shows
> (64-bit) on the big box.
>
> Rick Sawtell
>
>
Thank you I'll try that.|||Rick Sawtell wrote:
> "M Craig" <mcraig88@.newsgroups.nospam> wrote in message
> news:e3$w%23SJ6GHA.5068@.TK2MSFTNGP06.phx.gbl...
>
> SELECT @.@.VERSION -- 32 bit box
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:2
5
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Window
s
> NT 5.1 (Build 2600: Service Pack 2)
>
> SELECT @.@.VERSION -- 64 bit box
> 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)
>
> One is (Intel X86), the other (X64), also the Edition section shows
> (64-bit) on the big box.
>
> Rick Sawtell
>
>
Thank you I'll try that.|||It is Help Full,
jat,
http://www.earthsketch.com/seopage.html
M Craig wrote:
> Rick Sawtell wrote:
> Thank you I'll try that.