| Author |
Topic |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2004-10-25 : 10:54:29
|
| Hello All, Guys is there a way i can query SQL server to show me what SQL Server BIT version am i on.... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-25 : 11:29:55
|
From query analyzer: SELECT @@VERSIONMicrosoft SQL Server 2000 - 8.00.760 (Intel IA-64) Feb 6 2003 16:07:24 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: ) -ec |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-10-26 : 13:55:36
|
| No It doesn't show this part"Enterprise Edition (64-bit)"By the way i am using Standard Edition |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-26 : 14:24:31
|
| You would know it if you have a 64-bit system. Since you aren't sure, I'm positive that you have 32-bit.Tara |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-26 : 14:28:54
|
| the 64bit version is only available in the Enterprise Edition, not standard btw.-ec |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-26 : 14:38:03
|
| My guess is that it only shows (64-bit) when you are on just that.Mere mortals on 32-bit versions don't get the bit info..rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-10-27 : 09:42:25
|
| Is there any System Table or SP where i can get this kind of information? |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-10-27 : 09:47:57
|
| there's a system variable, @@version, that was quoted above. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-27 : 12:35:01
|
| Ricky, you have 32-bit version since you have Standard Edition installed.Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-10-27 : 13:52:32
|
| Thanks Tara!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-27 : 13:54:47
|
So you didn't see eyechart's post:quote:
the 64bit version is only available in the Enterprise Edition, not standard btw.
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-10-27 : 14:47:06
|
| I Saw that note. I agree that 64bit is only available in Enterprise Edition, not in standard edition. When i query Select @@verison Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6) There is no bit information. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-27 : 16:25:08
|
quote:
Originally posted by ricky_newbee
I Saw that note. I agree that 64bit is only available in Enterprise Edition, not in standard edition. When i query Select @@verison Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6) There is no bit information.
@@version only states 64 bit for the 64bit edition. all other versions of SQL Server are 32 bit.btw, you can also use the xp_msver extended sproc to return this type of info.-- Executed on 32bit hardwareexec master.dbo.xp_msver ProcessorTypeIndex Name Internal_Value Character_Value ------ -------------------------------- -------------- --------------------18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM(1 row(s) affected) -- Executed on 64bit hardwareexec master.dbo.xp_msver ProcessorTypeIndex Name Internal_Value Character_Value ------ -------------------------------- -------------- --------------------18 ProcessorType 2200 PROCESSOR_INTEL_IA64(1 row(s) affected) -ec |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-10-27 : 16:32:28
|
| Now this is good. Thanks 'EC' |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-27 : 16:46:10
|
quote:
Originally posted by ricky_newbee
Now this is good. Thanks 'EC'
check it out in BOL, there are about 20 values that it can return.-ec |
|
|
|
|
SQL Server 32-Bit and 64-Bit