There are some problems so far related to the SharePoint 2007 SP2. The last update comes from the Microsoft SharePoint Team Blog:

“During the installation of SP2, a product expiration date is improperly activated. This means SharePoint will expire as though it was a trial installation 180 days after SP2 is deployed. The activation of the expiration date will not affect the normal function of SharePoint up until the expiration date passes. Furthermore, product expiration 180 days after SP2 installation will not affect customer’s data, configuration or application code but will render SharePoint inaccessible for end-users.

We are working to release a hotfix to automatically fix this issue. A manual work-around is currently available and involves customers re-entering their Product ID number (PID) on the Convert License Type page in Central Administration.  For more information and detailed steps please read this KB article.”

Summary

There is a nice summary of know problems caused by SharePoint SP2 which is provided by Wictor Wilén.

• Important information on Service Pack 2 from the Microsoft SharePoint Team.

• Nintex Workflow 2007 problem with Service Pack 2

• Failure when running configuration wizard after applying SP2 (problem and solution)

• Problem with SQL Server and AWE memory allocation

• Some people says that it takes some time to start SharePoint after applying the update

• Me and some others had some problems when running the installer which was due to the fact that the download of the updates failed so the installation package was corrupt. I had to retry a few times to get all the bits

• SharePoint SP2 and SPDatabaseGbwSequence error is caused by free SharePoint templates

• SharePoint Designer needs Service Pack 2 to connect to a SharePoint Service Pack 2 farm

• MSI error 1603 while installing MOSS Service Pack 2

Please visit his blog to get more detailed information.