Showing posts with label SharePoint Versions. Show all posts
Showing posts with label SharePoint Versions. Show all posts

02 April, 2009

Microsoft Office SharePoint Server (MOSS 2007) Versions

How do you find out what version of SharePoint you are running?

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:
SELECT [VersionId]
,[Version]
,[Id]
,[UserName]
,[TimeStamp]
,[FinalizeTimeStamp]
,[Mode]
,[ModeStack]
,[Updates]
,[Notes]
FROM [SharePoint_Config].[dbo].[Versions]
WHERE VersionId = '00000000-0000-0000-0000-000000000000'
ORDER BY Id DESC
This returns :-





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]

WSS SP1:- Download

MOSS SP1:- Download

MOSS 2007 post SP1 hotfix KB941422

MOSS 2007 post SP1 hotfix KB941274

MOSS 2007 post SP1 hotfix KB948945

MOSS 2007 Infrastructure Update KB951695 & KB951297

MOSS 2007 Cumulative update KB956056 & KB956057