Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Conflicting Version number and Build Number on @@Version Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 2:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 8:26 AM
Points: 40, Visits: 286
Morning everyone.

I installed 2005 (X64) SP3 & 4 on a server over the weekend. An odd thing came up when I checked @@Version. Just for information purposes, the original SQL install already had Sp2, I just continued with 3 & 4.

Looking at another server which has all the service packs on it the @@Version reads..
Microsoft SQL Server 2005 - 9.00.5000.00 (X64)   Dec 10 2010 10:38:40   Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7600: ) 

9.00.5000.00 = Correct version
7600 = Correct build

The server which is giving me a conflicting @@Version reading..
Microsoft SQL Server 2005 - 9.00.5000.00 (X64)   Dec 10 2010 10:38:40   Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

9.00.5000.00 = Correct version
Build 3790: Service Pack 2 = ??

The machine appears to be working without any problem, I haven’t had any complaints..

I’ve been working with SQL for a very long time and have never seen anything like this.. My Google searching yielded nothing..

Do I perhaps uninstall SP 3 & 4 and start at 1 again??

Thanx for reading..
Post #1432104
Posted Monday, March 18, 2013 6:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 7,098, Visits: 12,605
Those components of @@VERSION speak to the OS, not SQL Server. Here is what I use to check what you're trying to check which ensures I only see the SQL Server properties and that they are not mixed with OS properties:

SELECT SERVERPROPERTY('Edition'), 
SERVERPROPERTY('ProductVersion'),
SERVERPROPERTY('ProductLevel');



__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1432178
Posted Monday, March 18, 2013 9:28 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 42,822, Visits: 35,953
No conflict.

Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)


SQL Server 2005 SP 4 X64 Standard Edition

on Windows NT 5.2 (Build 3790: Service Pack 2)


Running on the operating system NT 5.2 (Server 2003?) Service Pack 2.

and the other server:
Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)


SQL Server 2005 SP 4 X64 Standard Edition

on Windows NT 6.1 (Build 7600: )


Running on Server 2008 R2 RTM iirc



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1432230
Posted Tuesday, March 19, 2013 12:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 8:26 AM
Points: 40, Visits: 286
Thank you too everyone for their help..

Have an awesome day..
Post #1432487
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse