As I was looking around, I came across this upgrade check command in stsadm
This command scans your farm servers before starting an upgrade to ensure that some of the prerequisties are met for a successful upgrade.
This is only a guide and will not fix the problems itself.
Remember to work on a development environment and not production. Backup anything before you touch it – even if its your development environment!
The long awaited Service Pack 2 for SharePoint – MOSS 2007 and WSS 3.0 is out! There is much talk about installing it to fix certain security and performance issues.
But wait! Do you have an environment to test the installation? Have you read the known issues of SP2?