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.

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...
>> 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
>
>
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...
>> 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
>
>
Thank you I'll try that.|||It is Help Full,
jat,
http://www.earthsketch.com/seopage.html
M Craig wrote:
> Rick Sawtell wrote:
> > "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
> >
> >
> >
> Thank you I'll try that.sql

How to find version (build)

How do you find out what version of SQL 2000 you are running?
I need to load build 8.00.534 to solve my problem connecting using
linked servers with a Progress database as this is supposed to fix our
problem.
Thanks,
Tom.
Hi,
Execute the below command from Query Analyzer:-
Select @.@.version
8.00.534 is for SP2 , after that install the patch for slammer worm as well.
Check the versions and build number in below site :-
http://www.krell-software.com/mssql-builds.htm
Thanks
Hari
MCDBA
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using
> linked servers with a Progress database as this is supposed to fix our
> problem.
> Thanks,
> Tom.
>
|||SELECT @.@.VERSION ? http://www.aspfaq.com/2160
I strongly, strongly, strongly recommend using this build only for the
required time and only if you are installing it on an isolated machine. If
this build is exposed to the Internet, you are very likely to be complaining
of Slammer very soon...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using linked
> servers with a Progress database as this is supposed to fix our problem.
> Thanks,
> Tom.
>

How to find version (build)

How do you find out what version of SQL 2000 you are running?
I need to load build 8.00.534 to solve my problem connecting using
linked servers with a Progress database as this is supposed to fix our
problem.
Thanks,
Tom.Hi,
Execute the below command from Query Analyzer:-
Select @.@.version
8.00.534 is for SP2 , after that install the patch for slammer worm as well.
Check the versions and build number in below site :-
http://www.krell-software.com/mssql-builds.htm
Thanks
Hari
MCDBA
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using
> linked servers with a Progress database as this is supposed to fix our
> problem.
> Thanks,
> Tom.
>|||SELECT @.@.VERSION ? http://www.aspfaq.com/2160
I strongly, strongly, strongly recommend using this build only for the
required time and only if you are installing it on an isolated machine. If
this build is exposed to the Internet, you are very likely to be complaining
of Slammer very soon...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using linked
> servers with a Progress database as this is supposed to fix our problem.
> Thanks,
> Tom.
>

How to find version (build)

How do you find out what version of SQL 2000 you are running?
I need to load build 8.00.534 to solve my problem connecting using
linked servers with a Progress database as this is supposed to fix our
problem.
Thanks,
Tom.Hi,
Execute the below command from Query Analyzer:-
Select @.@.version
8.00.534 is for SP2 , after that install the patch for slammer worm as well.
Check the versions and build number in below site :-
http://www.krell-software.com/mssql-builds.htm
Thanks
Hari
MCDBA
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using
> linked servers with a Progress database as this is supposed to fix our
> problem.
> Thanks,
> Tom.
>|||SELECT @.@.VERSION ? http://www.aspfaq.com/2160
I strongly, strongly, strongly recommend using this build only for the
required time and only if you are installing it on an isolated machine. If
this build is exposed to the Internet, you are very likely to be complaining
of Slammer very soon...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using linked
> servers with a Progress database as this is supposed to fix our problem.
> Thanks,
> Tom.
>