32 or 64 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

32 or 64

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-27 : 15:38:40

How to findout whether a server is 32 or 64 bit? What should i look for in @@version?

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-27 : 15:41:25

Look for X32/X64.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-27 : 15:46:49

>> Look for X32/X64.
There is no X32/X64!

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-27 : 15:48:02

I guess I have to be explicit. Look for X32 or X64 in @@VERSION. Here is an example:

x64:
Microsoft SQL Server 2005 - 9.00.3200.00 (X64) Oct 2 2007 12:23:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

x32:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-27 : 15:53:30

It has to be X86/X64!

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-27 : 15:58:00

That's what I meant. I'm sure you could have figured that out on your own.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-27 : 16:05:16

Thanks Tara.

------------------------
I think, therefore I am - Rene Descartes

mdubey
Posting Yak Master

133 Posts

Posted - 2008-05-27 : 16:25:07

This step-by-step article describes how to determine whether a computer is running a 32-bit Microsoft Windows operating system or a 64-bit Microsoft Windows operating system. To determine whether your computer is running a 32-bit Windows operating system or a 64-bit Windows operating system, examine the system information. To do this, use one of the following methods.

Note Intel Itanium-based computers can only run 64-bit versions of Windows. Intel Itanium-based computers cannot run a 32-bit Windows operating system. Currently, 64-bit versions of Windows only run on Itanium-based computers and AMD64-based computers.

Windows Vista
Method 1
1. Click Start, type system in the Start Search box, and then click system in the Programs list.
2. The operating system appears as follows:• For a 64-bit version operating system: 64-bit Operating System appears for the System type under System.
• For a 32-bit version operating system: 32-bit Operating System appears for the System type under System.

Method 2
1. Click Start, type system in the Start Search box, and then click System Information in the Programs list.
2. The operating system appears as follows:• For a 64-bit version operating system: x64-based PC appears for the System type under Item.
• For a 32-bit version operating system: x86-based PC appears for the System type under Item.

Microsoft Windows XP Professional
Method 1
1. Click Start, click Run, type sysdm.cpl, and then click OK.
2. Click the General tab. The operating system appears as follows:• For a 64-bit version operating system: Microsoft Windows XP Professional x64 Edition Version < Year> appears under System.
• For a 32-bit version operating system: Microsoft Windows XP Professional Version< Year> appears under System.
Note <Year> is a placeholder for a year.

Method 2
1. Click Start, click Run, type winmsd.exe, and then click OK.
2. In the details pane, locate Processor under Item. Note the value. • If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system.
• If the value that corresponds to Processor starts with ia64 or AMD64, the computer is running a 64-bit version of the Windows operating system.

Microsoft Windows Server 2003
Method 1
1. Click Start, click Run, type sysdm.cpl, and then click OK.
2. Click the General tab. The operating system appears as follows:• For a 64-bit version operating system: Microsoft Windows Server 2003 Enterprise x64 Edition appears under System.
• For a 32-bit version operating system: Microsoft Windows Server 2003 Enterprise Edition appears under System.

Method 2
1. Click Start, click Run, type winmsd.exe, and then click OK.
2. In the details pane, locate Processor under Item. Note the value. • If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system.
• If the value that corresponds to Processor starts with EM64T or ia64, the computer is running a 64-bit version of the Windows operating system.

Manoj
MCP, MCTS

karuna
Aged Yak Warrior

582 Posts

Posted - 2008-05-27 : 16:59:57

mdubey,

First, this was already answered.
Second, Did you even read the question??? I believe ravilobo was asking about Sql Server Version and not OS version

Thanks
Karunakaran

monty
Posting Yak Master

130 Posts

Posted - 2008-05-27 : 21:05:57

correct,

i have seen enough posts where this guy posts just for the heck of posting.. this forum is doing so much of help for many ppl around the globe, Mdubey plz make a note of it.

its me monty

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2008-05-29 : 09:11:38

And besides, if it were an operating system question the answer is even shorter than that novel - msinfo32.exe.

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-29 : 09:16:58

quote:
Originally posted by tfountain
....- msinfo32.exe.

This is nice.

------------------------
I think, therefore I am - Rene Descartes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources