What version is 9.00.2047.00?

Question

Post reply

What version is 9.00.2047.00?

FreeHansje

SSChampion

Points: 11751
More actions
March 6, 2007 at 8:28 am

#116008

Title says it. SP 2 has version 9.00.3042, when I look at sp 1 I see the number 1.00.0080?! I don't know if hotfixes are applied, nobody can tell me.
Greetz,
Hans Brouwer

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

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

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 1

9.00.2047 is SP1.

Take a look at here: http://support.microsoft.com/?kbid=321185

FreeHansje SSChampion Points: 11751 More actions · Answer 2

Right, tnx. I looked here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en

Greetz,
Hans Brouwer

Shannon Hall SSC Journeyman Points: 77 More actions · Answer 3

I believe 9.00.2047.00 is SP1 with the Hotfixes or at least that's what I have in my environment, but after SP2 I get 9.00.3042.

David Diener SSC-Addicted Points: 410 More actions · Answer 4

SQL Server 2005 Version 9.0.2047 is Service Pack 1.

SQL Server 2005 Version 9.0.2153 is Service Pack 1 with the Culmulative Hotfix applied.

Kindest Regards,

(Anonymous) SQL Server DBA

Jim Holcomb Right there with Babe Points: 722 More actions · Answer 5

Try this:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

maurizio-489530 SSC Journeyman Points: 75 More actions · Answer 6

Hi there i somewhat have a similar problem

i'm a trainee and i have to figure out which

patches are installed this is the info i have so far

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

i have several version with service pack 1 and 2 but i dont know why they different or where i can see what hotfixes are installed

hope one of you can help me

regards

Antares686 SSC Guru Points: 125444 More actions · Answer 7

http://www.sqlsecurity.com has a database of all versions almost as quickly as they become available. You can find your patching level there and has links to non-PSS downloads.