|
Home > Archive > MS SQL Server > August 2005 > SQL SERVER Edition
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL SERVER Edition
|
|
|
| Hello Everybody,
I have SQL SERVER Enterprise Edison install on our server...How can i know
whether is it 32 bit or 64 bit ? which is the most common version (32 bit or
64 bit ) client use now a days ?
| |
| Mike Epprecht (SQL MVP) 2005-08-30, 11:23 am |
| Hi
select @@version will return "(Intel X86)" as part of the string for 32 Bit.
There are still more 32bit installs than 64bit Itanium installs.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mvp" wrote:
> Hello Everybody,
> I have SQL SERVER Enterprise Edison install on our server...How can i know
> whether is it 32 bit or 64 bit ? which is the most common version (32 bit or
> 64 bit ) client use now a days ?
| |
|
| I ran that and i got
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
still it doesn't say any where whether is it 32 bit or 64 bit ?
thx
"Mike Epprecht (SQL MVP)" wrote:
[color=darkred]
> Hi
>
> select @@version will return "(Intel X86)" as part of the string for 32 Bit.
>
> There are still more 32bit installs than 64bit Itanium installs.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
>
>
> "mvp" wrote:
>
| |
| Mike Epprecht (SQL MVP) 2005-08-30, 11:23 am |
| Hi
For SQL Server 2000, "Intel X86" implies 32bit version.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mvp" wrote:
[color=darkred]
> I ran that and i got
>
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: )
>
>
> still it doesn't say any where whether is it 32 bit or 64 bit ?
>
> thx
>
> "Mike Epprecht (SQL MVP)" wrote:
>
| |
|
| Oh Ok.
Thanks for the quick replies.
Just want to know, i have Windows 2003 SERVER O/S install on my server, can
i install 64 bit version of sql server ? What are the procs and cons of
windows 64 bit versions ?
thx
"Mike Epprecht (SQL MVP)" wrote:
[color=darkred]
> Hi
>
> For SQL Server 2000, "Intel X86" implies 32bit version.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
>
>
> "mvp" wrote:
>
| |
| Mike Epprecht \(SQL MVP\) 2005-08-30, 8:23 pm |
| SQL Server 2000 64 Bit only runs on an Itanium.
SQL Server 2005 64 Bit only runs on an Itanium and there is a separate build
for X64/EM64T processors.
There have been a few discussions on this in these newsgroups. Have a Google
for them.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mvp" <mvp@discussions.microsoft.com> wrote in message
news:31095334-0BD7-4584-9934- 877BFA59B7A9@microso
ft.com...[color=darkred]
> Oh Ok.
> Thanks for the quick replies.
> Just want to know, i have Windows 2003 SERVER O/S install on my server,
> can
> i install 64 bit version of sql server ? What are the procs and cons of
> windows 64 bit versions ?
>
>
> thx
>
> "Mike Epprecht (SQL MVP)" wrote:
>
|
|
|
|
|