How to check the SharePoint 2010 and Project Server 2010 service pack / patch level #PS2010 #ProjectServer #SharePoint #SP2010

July 8, 2011 at 7:59 pm | Posted in Administration | 1 Comment
Tags: , , ,

This article will show how to check the farm version for SharePoint Foundation 2010, SharePoint Server 2010 and Project Server 2010.

The farm patch level can be check in the Central Administration site, click “Upgrade and Migration” then “Check Product and Patch Installation Status”


The patch level of all farm components will be detailed here, as you can see below, Project Server is listed at the bottom:


The farm configuration database version can also be checked on the “Manage Servers in this farm” page:


You can also check the SQL databases directly just running the query below:

select     version
        ,    ID
        ,    UserName
        ,    TimeStamp
from versions

Or if you want to see everything:

Select * from versions

This query can be executed against most of the SharePoint 2010 databases and all of the Project Server 2010 PWA databases. Worth noting is that not all SharePoint databases have a versions table, also not all of the versions tables get updated with every update, it usually depends if there is a schema update.


1 Comment

  1. […] How to check the #Project Professional 2010 service pack / patch level #ProjectServer #PS2010 July 18, 2011 at 1:33 pm | Posted in Administration, Installation | Leave a comment Tags: Project 2010, Project Server 2010, PS2010 Following on from a previous article relating to checking the farm patch level, I have quickly documented how to check Project Professional 2010 patch level below. The previous article can be found here:… […]

Sorry, the comment form is closed at this time.

Blog at
Entries and comments feeds.

%d bloggers like this: