Working with a few customers we found a couple of interesting management style queries that weren’t so easy to do through the user interface. No problem, Lee went ahead and documented the T-SQL for the queries and important parts of the MessageBox database to make it easier for DBAs/IT Pros to understand. Check it out here.
N.B. Handle this stuff with caution, and make sure you read the part of the document that talks about never ever ever modifying the MessageBox database.