MysteryJimbo (10/11/2010)
There's no way of doing it through management studio.I accomplished this by using powershell and combining multiple resultset along with @@SERVERNAME into a $variable and pinging a HTML email report with the result.
This sounds like exactly what I need to do. Can you post some code?