| Author |
Topic |
|
DBA in the making
Aged Yak Warrior
638 Posts |
 Posted - 2012-02-29 : 04:21:22
|
| When I run "PRINT @@VERSION" on a SQL Server 2005 Enterprise x64, what should the result look like? I'm getting "Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)", which suggests that it's not x64 at all.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-29 : 04:31:30
|
Please can you show the complete result string?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2012-02-29 : 04:38:52
|
Sure. The complete string is:Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-29 : 04:57:08
|
looks like it isn't x64.What gives this?SELECT 'SQL Server ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR(255)) + ' - ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR(255)) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR(255)) + ')'
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2012-02-29 : 05:12:56
|
quote:
Originally posted by webfred
looks like it isn't x64.
I agree, I just want to make 100% sure, before I raise an issue over it. I'd hate to end up with egg on my face. quote:
What gives this?SELECT 'SQL Server ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR(255)) + ' - ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR(255)) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR(255)) + ')'
No, you're never too old to Yak'n'Roll if you're too young to die.
That returned:SQL Server 9.00.5000.00 - SP4 (Enterprise Edition)------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-29 : 05:15:39
|
No eggs - it isn't x64 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2012-02-29 : 05:16:38
|
quote:
Originally posted by webfred
No eggs - it isn't x64
No, you're never too old to Yak'n'Roll if you're too young to die.
Thank you.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-29 : 05:18:25
|
Your Server is running on MS Windows 2003 (NT 5.2) and the next step would be to check it is x64 or not. If not then it is clear why sql server isn't x64.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
Just a quick question