how to find out 32/64 bit installation

Hi,

How of find out if SQL Server installed is 32bit or 64bit edition?

what it will return if it is 64 bit

using select @@version it returns

"Microsoft SQL Server 2000 - 8.00.911 (Intel X86) Jan 29 2004 13:24:35 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"

can anyone send the output of 64 bit version using select @@version?

xp_msver too doesnt explicitly say whether the machine is 64 or 32

Thanks,
Ram

"It is easy to write code for a spec and walk in water, provided, both are freezed..."

I heard that if it is 64 bit, select @@version will display 64 bit in braces. For 32 bit it is not.

You can also get the info from the command prompt c:>sqlserv.exe -v or

select serverproperty('edition')

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ramasubbup</i><br /><br />I heard that if it is 64 bit, select @@version will display 64 bit in braces. For 32 bit it is not.<br /><br />You can also get the info from the command prompt c:&gt;sqlserv.exe -v or <br /><br />select serverproperty('edition')<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Ramasubbu,<br /><br />Serverproperty('Edition') doesnt give you the info about 64 and 32 bit.. I referred in BOL,<br /><br />Edition The edition of the Microsoft® SQL Server™ instance installed on the server. <br />Returns:<br /><br />'Desktop Engine'<br />'Developer Edition'<br />'Enterprise Edition'<br />'Enterprise Evaluation Edition'<br />'Personal Edition'<br />'Standard Edition'<br /><br />Base data type: nvarchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br /> <br />and pathetically i am getting an acces denied message if i run the command prompt<br /><br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."

quote:Originally posted by satya

Edition reference is different from the installation type of 32 bit or 64 bit, if you're getting access denied then make sure you have admin rights on the server.

Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Yes I do. i am a local administrator to the machine

Thanks,
Ram

"It is easy to write code for a spec and walk in water, provided, both are freezed..."

If you have a 64-bit Intel box, you will get something like this when you run SELECT @@VERSION

"Microsoft SQL Server 2005 - 9.00.1399.06 (Intel IA-64)"

Note: IA-64 instead of X86

Nathan H. Omukwenyi
MVP [SQL Server]

Thanks. This clarifies the original question of this forum.


can you also please specify what will be output for the following commands in 64-bit version
Just to see that if they also returns the required info

1. master..xp_msver
and
2. select serverproperty('edition')

Here is the output of master..xp_msver
and select serverproperty('edition') on a 64-bit environment

-------------------------------------------------------
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 589824 9.00.2047.00
3 Language 1033 English (United States)
4 Platform NULL NT AMD64
5 Comments NULL NT AMD64
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT - 64 Bit
8 FileVersion NULL 2005.090.2047.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 134152192 NULL
15 WindowsVersion 248381957 5.2 (3790)
16 ProcessorCount 4 4
17 ProcessorActiveMask 4 f
18 ProcessorType 8664 NULL
19 PhysicalMemory 8023 8023 (8413024256)
20 Product ID NULL NULL
-------------------------------------------------------


Here is the output of select serverproperty('edition')
-------------------------------------------------------
Enterprise Edition (64-bit)

what are these 64 and 32 all about? can anyone brief me??

Thanks,
Ram

"It is easy to write code for a spec and walk in water, provided, both are freezed..."

CPU (processor) architectures.

http://en.wikipedia.org/wiki/64-bit]


Nathan H. Omukwenyi
MVP [SQL Server]

quote:Originally posted by vbkenya

CPU (processor) architectures.

http://en.wikipedia.org/wiki/64-bit]


Nathan H. Omukwenyi
MVP [SQL Server]

This is Cool. Thanks for the link.

Thanks,
Ram

"It is easy to write code for a spec and walk in water, provided, both are freezed..."