Here is a list of KB articles that may be of importance, both pre-deployment and post deployment of Service Pack 2.  This list will be updated as new KB articles come on-line.

General:

List of all 2007 Office system Service Pack 2 and Windows SharePoint Services 3.0 Service Pack 2 packages
http://support.microsoft.com/kb/968170/

Description of Office SharePoint Designer 2007 Service Pack 2 (SP2) and of Office SharePoint Designer Language Pack 2007 Service Pack 2 (SP2)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;953292

List of all Windows SharePoint Services and SharePoint Server Pre-Upgrade Checker knowledge base articles
http://support.microsoft.com/kb/960577/

Known issues that you may experience when you install the 2007 Microsoft Office suite Service Pack 2 and Windows SharePoint Services 3.0 Service Pack 2 
http://support.microsoft.com/kb/968173/

WSS:

Technical details about the Windows SharePoint Services 3.0 Service Pack 2 (SP2) releases
http://support.microsoft.com/default.aspx?scid=kb;EN-US;970359

Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;953338

Windows SharePoint Services 3.0 Service Pack 2 provides a change in the way that a Windows SharePoint Services site that is in forms-based authentication mode responds to an anonymous access request from SharePoint Designer 2007
http://support.microsoft.com/kb/968788/

You may be unable to delete certain site collections in Windows SharePoint Services 3.0
http://support.microsoft.com/kb/968787/

After you install Windows SharePoint Services 3.0 Service Pack 2, the Windows SharePoint Services 3.0 database can be auto-defragmented
http://support.microsoft.com/kb/968785/

Windows SharePoint Services 3.0 Service Pack 2 provides support for host header-based site collection crawls
http://support.microsoft.com/kb/968786/

Groove, Groove Server, InfoPath, InfoPAth Server, Outlook, and WSS all block new files with the installation of SP2
http://support.microsoft.com/kb/968768/

Windows SharePoint Services 3.0 Service Pack 2 provides a change in the way that a Windows SharePoint Services site that is in forms-based authentication mode responds to an anonymous access request from SharePoint Designer 2007
http://support.microsoft.com/default.aspx?scid=kb;EN-US;968788

Error message when you try to install an update for 2007 Office programs or Windows SharePoint Services 3.0 if the Windows system drive has insufficient free disk space: "The installation of this package failed"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;943589

MOSS:

Technical details about the 2007 Microsoft Office Servers Service Pack 2 (SP2) releases
http://support.microsoft.com/default.aspx?scid=kb;EN-US;970358

Description of 2007 Microsoft Office servers Service Pack 2 (SP2) and of 2007 Microsoft Office servers Language Pack Service Pack 2 (SP2)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;953334

You are prompted unexpectedly to restart the computer after you install a 2007 Office service pack or a 2007 Office update
http://support.microsoft.com/default.aspx?scid=kb;EN-US;942995

No SharePoint Server 2007 Service Pack 2 .msp files are installed if you have the Stswwsp1.msp file in the Updates folder
http://support.microsoft.com/default.aspx?scid=kb;EN-US;968283

The Area Service Web service is removed from SharePoint Server 2007 after you install the 2007 Microsoft Office servers Service Pack 2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;968998

When you query a new user property in Microsoft Office SharePoint Server 2007, nothing is returned
http://support.microsoft.com/default.aspx?scid=kb;EN-US;968778