February, 2009

The first approach is to open a web browser and got to the site settings page

(Site Actions > Site Settings > Modify All Settings).

The second approach is against the databases. Open SQL Server Management Studio, Connect to the server, new query, run the following:

Use Sharepoint_ConfigDb

SELECT *

FROM Versions

WHERE VersionId = '00000000-0000-0000-0000-000000000000'

ORDER BY Id DESC

This returns (columns reduced for readability):

VersionId Version Id UserName Updates

00000000-0000-0000-0000-000000000000 12.0.0.6219 4 MOSS\user 3

00000000-0000-0000-0000-000000000000 12.0.0.4518 1 MOSS\user 2

The top row is the latest version. The query is performed on the SharePoint Configuration database. If you have called this database something instead of "SharePoint_Config" change the query to reflect this.

You can also look at the versions for Content Databases, by changing the database name. For example: FROM WSS_Content_MySites.[dbo].[Versions]

MOSS Product Version

MOSS 2007 OCT Cumulative update 12.0.0.6331

MOSS 2007 Aug Cumulative update 12.0.0.6327

MOSS 2007 Infrastructure Update 12.0.0.6318

MOSS 2007 post SP1 hotfix KB948945 12.0.0.6303

MOSS 2007 post SP1 hotfix KB941274 12.0.0.6301

MOSS 2007 post SP1 hotfix KB941422 12.0.0.6300

MOSS 2007 SP1 12.0.0.6219

MOSS 2007 October public update 12.0.0.6039

MOSS 2007 August 2007 hotfix 12.0.0.6036

MOSS 2007 RTM 12.0.0.4518

FOR PROJECT SERVER 2007

**************************

Use ProjectServer_Published

SELECT *

FROM Versions

WHERE VersionId = '00000000-0000-0000-0000-000000000000'

ORDER BY Id DESC

*For Project Client you can check from Project Professional >>Help >>About Microsoft Office Project