Conflicting Version number and Build Number on @@Version

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Conflicting Version number and Build Number...

Conflicting Version number and Build Number on @@Version

Rate Topic

Display Mode

Topic Options

Author

Message

Mark Kinnear

Posted Monday, March 18, 2013 2:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 1:25 AM
Points: 40, Visits: 264

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 = ?? Crazy

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

opc.three

Posted Monday, March 18, 2013 6:56 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:59 AM
Points: 6,703, Visits: 11,732

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1432178

GilaMonster

Posted Monday, March 18, 2013 9:28 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943

No conflict.

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:

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

Mark Kinnear

Posted Tuesday, March 19, 2013 12:29 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 1:25 AM
Points: 40, Visits: 264

Thank you too everyone for their help.. Smile

Have an awesome day..

Post #1432487

« Prev Topic | Next Topic »

Permissions