Database at 9.0.3152 but SSMS at 9.0.3042 - Problem?

I've got a SQL 2K5 installation that I have upgraded to 9.0.3152. In SSMS, I see the SQL Server instance showing with the correct version - 9.0.3152. But SSMS (Help->About) shows a version of 9.00.3042. Is this expected or should "Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available" (http://support.microsoft.com/default.aspx/kb/933097/) have upgraded all these to 3152, as well?

Thanks!

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

There are several ways to check the version level of various components. The easiest seems to be by using Add/Remove Programs. Click on your SQL entry, then uninstall, and then Change. This pops up a nice report showing your machine at the component level and the associated versions. If SSMS is at 3042, you can apply hotfix 3152 and bring it up to date. My guess is that SSMS might not show the hotfix level (only the SP level) and that your box is updated already.

Thanks,

Sam Lester (MSFT)

|||

Really it may not be the easiest way for remote server.

Iа I were you (or if you were I), I would have preferred

SERVERPROPERTY function.

SELECT SERVERPROPERTY('productversion') AS ProductVersion,

SERVERPROPERTY ('ResourceVersion') As ResourceVersion ,

SERVERPROPERTY ('productlevel') AS ProductLevel,

SERVERPROPERTY ('edition') As Edition,

SERVERPROPERTY ('ResourceLastUpdateDateTime') As ResourceLastUpdateDateTime

Shows for me
ProductVersion ResourceVersion ProductLevel Edition ResourceLastUpdateDateTime
9.00.3054.00 9.00.3042 SP2 Developer Edition 2007-02-10 00:39:35.480