32 bit or 64 bit

Question

32 bit or 64 bit

Krasavita

SSC-Insane

Points: 23138
More actions
December 9, 2009 at 10:54 am

#72556

How to know if I in 32 bit or 64 bit enviroment.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

Krasavita (12/9/2009)
How to know if I in 32 bit or 64 bit enviroment.

Right click on SQL Instance in SSMS, select properties, the initial properties windows lists the Server information, Product shows the SQL Server Edition and if it is 64 bit, it shows (64-bit)

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Ask your system admin.

You can also run this in Query Analyser: select @ @ version (no spaces after the @ signs). If you see x64 in the returned string you are in a 64-bit environment; if you see x86 then it is a 32-bit environment.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Bru Medishetty (12/9/2009)
Krasavita (12/9/2009)
How to know if I in 32 bit or 64 bit enviroment.
Right click on SQL Instance in SSMS, select properties, the initial properties windows lists the Server information, Product shows the SQL Server Edition and if it is 64 bit, it shows (64-bit)

May not work in this case. OP is probably using Enterprise Manager/Query Analyzer based on the forum (SQL Server 7, 2000) that this question is posted. 😉

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 4

Oops I see it now.

I am habituated working in SSMS even with SQL 2000 Servers.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Krasavita SSC-Insane Points: 23138 More actions · Answer 5

This is what I get:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I don't see 32 or 64

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Krasavita (12/9/2009)
This is what I get:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I don't see 32 or 64

Look at what I have emphasised above. Then, reread my previous post.

Krasavita SSC-Insane Points: 23138 More actions · Answer 7

Krasavita

SSC-Insane

Points: 23138

December 9, 2009 at 11:14 am

#1090063

Thank you

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 8

Lynn Pettis (12/9/2009)
Krasavita (12/9/2009)
This is what I get:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I don't see 32 or 64
Look at what I have emphasised above. Then, reread my previous post.

Don't have time to read previous replies, can you spare some time to reply once more. 😛 😛

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 9

Bru -

Note the Intel x86 in the string that Lynn was pointing out.

You must be having a long day.

Greg E

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 10

Greg Edwards-268690 (12/9/2009)
Bru -
Note the Intel x86 in the string that Lynn was pointing out.
You must be having a long day.
Greg E

Greg, I did read Lynn's reply earlier, I sent it for fun.. (keeping OP in mind)

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Bru Medishetty (12/9/2009)
Lynn Pettis (12/9/2009)
Krasavita (12/9/2009)
This is what I get:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I don't see 32 or 64
Look at what I have emphasised above. Then, reread my previous post.
Don't have time to read previous replies, can you spare some time to reply once more. 😛 😛

Humour, Greg, Humour. He caught it. Look at the emoticons. 😉

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 12

Lynn Pettis (12/9/2009)
Bru Medishetty (12/9/2009)
Lynn Pettis (12/9/2009)
Krasavita (12/9/2009)
This is what I get:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I don't see 32 or 64
Look at what I have emphasised above. Then, reread my previous post.
Don't have time to read previous replies, can you spare some time to reply once more. 😛 😛
Humour, Greg, Humour. He caught it. Look at the emoticons. 😉

Heh... forget the emoticons... look at this avatar. :-):-D:-P;-):hehe:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 13

Bru Medishetty (12/9/2009)
Greg Edwards-268690 (12/9/2009)
Bru -
Note the Intel x86 in the string that Lynn was pointing out.
You must be having a long day.
Greg E
Greg, I did read Lynn's reply earlier, I sent it for fun.. (keeping OP in mind)

I must need a vacation really bad.

I completely missed the pictures to clarify your response.:w00t:

Greg E