March 18, 2013 at 2:31 am
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..
March 18, 2013 at 6:56 am
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
March 18, 2013 at 9:28 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2013 at 12:29 am
Thank you too everyone for their help..:-)
Have an awesome day..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply