March 25, 2010 at 3:52 pm
Hi,
I did the isntall of SP3 on my SQL 2005 server. After the install I am still getting SP2 when I run select @@version:
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
How come I am still on SP2?
Thanks,
Rem
March 25, 2010 at 3:57 pm
and where should I go to get Cumulative update package 8 for SQL Server 2005 Service Pack 3?
March 26, 2010 at 1:28 am
Hi,
This version: 9.00.4035.00 (X64) is not SP2, is SP3.
Wish you good ideas! 🙂
Andreea
March 26, 2010 at 1:32 am
To be more specific, many people are confused when looking to this info.
It is like that:
this is the Sql Server 2005 info:
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005
this is the OS info:
Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
The Service Pack2 is about the OS.
If you have more questions...
Wish you good ideas! 🙂
Andreea
March 26, 2010 at 2:30 am
Rem,
Check out this link
http://qa.sqlservercentral.com/articles/Administration/2960/
even has links to Cumulative Updates!
March 26, 2010 at 5:10 am
This can help you select serverproperty ('productlevel')
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 26, 2010 at 5:19 am
Better still...
SELECT SERVERPROPERTY('productversion') AS 'SQL Build', SERVERPROPERTY ('productlevel') AS 'Service Pack', SERVERPROPERTY ('edition') AS 'SQL Edition' Order by 'SQL Build'
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply