Author: Tobias Zimmergren
URL: http://www.zimmergren.net

Introduction

Previous major updates for SharePoint related technologies has been:

• Service Pack 1
• Infrastructure Updates
• Misc. Rollups

Today - as promised - Microsoft released the next set of updates called Service Pack 2.

For an overview of major updates and rollups/cumulative updates post SP1, check out my mate Spence's awesome blog here: http://www.harbar.net/articles/postsp1.aspx

The new WSS 3.0 SP2 brings this to the table:

Quoted from the Microsoft sites in the links section below!

Some big areas of the improvements that the Windows SharePoint Services team wanted to highlight:

• Faster, more reliable content migration and data backup and restore
• Reduced memory consumption
• Smoother upgrade experience
• Significant database performance adjustments
• Updated integration for forms authentication
• Advanced permission management
• Helpful administrative tools
• Expanded browser compatibility

The new MOSS 2007 SP2 brings this to the table:

Quoted from the Microsoft sites in the links section below!

Microsoft Enterprise Content Management (ECM)

• Improves the performance and stability of the content deployment feature and of the Variations feature.
• Adds a new command to the Stsadm.exe tool. This tool provides the following functionality:
  • Lets a SharePoint administrator use the Variations feature to scan a site for errors, report the errors, and fix certain problems.
  • Finds and repairs missing peer relationships and corrupted entries in the internal variations relationships list.
  • Handles the propagation of large volumes of variations content in a more manageable way.

Microsoft Office Excel and Microsoft Office Access services

• Fixes Open Snapshot so that snapshots open more reliably, even if there is no SharePoint root site.
• Fixes display issues that cause calculations to appear incorrect in some cases.
• Improves connections to cubes by using .odc files in non-English cases.
• Improves the performance of programmatic scenarios.
• Fixes conditional formatting in Mozilla Firefox browsers.
• Improves support for generating Excel Web Access Web parts on new sites.

Microsoft Office Groove Server (64-bit version only)

• Office Groove Server 2007 Data Bridge now limits the number of file-sharing workspaces to 64 to make sure that all workspaces can be synchronized. This limit applies only to newly added file-sharing workspaces. If you already have more than 64 file-sharing workspaces, you can continue to use them.
• Improves synchronization reliability.
• Groove Server 2007 Manager can be installed and run with SQL Server 2008.
• Improves the Groove Lightweight Directory Access Protocol (LDAP) connectivity and auto-activation functionality.
• Improves error reporting in the Groove Relay Server.
• Improves the robustness of Groove Relay Server.

Microsoft Office Forms Server

• Improves performance of large browser forms on InfoPath Form Services, both for memory usage and for page load time.
• Improves reliability of Forms Server and of Microsoft Office SharePoint Server by addressing the previous behavior in which an upgrade of an administrator-approved form template triggers an IIS reset.
• Improves the Digital Signature functionality for InfoPath Forms Services.

Microsoft Office Project Server

• Modifies the queue service to prevent it from using large volumes of memory over long periods.
• Improves the performance of certain database table indexes.
• Improves cost resource functionality. For example, the server now correctly handles tasks that have material or work resources assigned to the same task.
• Improves certain areas such as resource plans, build team, and the server scheduling engine.

Microsoft Office Search Server

• Improves the reliability and stability of WSS crawl, of SharePoint crawl, of crawling through a very large corpus, and of backup restore.
• Introduces a new command to the Stsadm.exe tool that lets a SharePoint administrator tune the Query processor multiplier parameter. For example, the Query processor multiplier can be used to tune the query performance for SSP indexing content sources that have highly restrictive permissions and many duplicates.
• Improves the accuracy of searches that involve numbers. For example, there is additional support for large numbers in which a comma is used to separate every three digits (for example, 1,000,000), for numbers that are between 9 and 40 characters, and for numbers that are separated by spaces.

Platform support

• Provides full support for Windows Internet Explorer 8.
• Provides level 2 browser support for Mozilla Firefox (versions 2 and 3).
  • For more information about browser support levels, visit the following Microsoft Web site:

    http://office.microsoft.com/en-us/sharepointserver/HA101945391033.aspx (http://office.microsoft.com/en-us/sharepointserver/HA101945391033.aspx)

• Provides support for Windows Server 2008

Summary, Links & Downloads

MOSS 2007
Download: MOSS 2007 SP2 Download
KB: MOSS 2007 SP2 Knowledge Base Article

WSS 3.0
Download: WSS 3.0 SP2 Download
KB: WSS 3.0 SP2 Knowledge Base Article