Version of SQL 2005

Question

Version of SQL 2005

leemunyasia

SSC Veteran

Points: 235
More actions
November 10, 2011 at 3:26 am

#262530

Hi fellow SQL affiliates,
I would like to update our server to SQL 2005 SP 2 on out Database hotel. Now I have two differe between the below two version?
Microsoft SQL Server 2005 - 9.00.4060.00 (X64) Mar 17 2011 13:06:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
and
Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Kind regards
Lee

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Those are both running SP3 or close to it, so they're well fast the SP2 you want to install. Installing SP4 would be a good idea.

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

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

leemunyasia SSC Veteran Points: 235 More actions · Answer 2

OK, thanks for the quick reply though one thing is not very clear:

It says Service pack 2 at the very end, what I am trying to establish is:

1) Difference btwn what I have underlined 9.00.4060.00 and 9.00.4053.00?

2) If I was/am running on SP3 why does it stay SP2 at the very end of the @@version query?

Kind regards

Lee

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

leemunyasia (11/10/2011)
It says Service pack 2 at the very end, what I am trying to establish is:

What it says at the end is "Windows NT 5.2 (Build 3790: Service Pack 2)"

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

Lee

(1) http://www.sqlservercentral.com/articles/Administration/2960/

(2) That's the Windows version.

John

leemunyasia SSC Veteran Points: 235 More actions · Answer 5

thanks, I now understand that the version related is the winders version.

I am running on the below:

Windows Server 2003 standard x64Edition: Version 5.2 build 3790.srv03_sp2_gdr.1010119-0340: Service pack 2)

Meet George Jetson SSChampion Points: 11692 More actions · Answer 6

As Gail mentioned, both are already at Service Pack 3, although the 9.00.4060 is a hotfix for a specific issue you must have had.

Please take a look at the following site, it lists all available versions and updates.

http://sqlserverbuilds.blogspot.com/

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

Version of SQL 2005

Cookies on SQLServerCentral