Due to my access restrictions, I can't use that and I don't need that much detailed level of informtion. Is there any other script that I can use to send...

This is something like I need to send an email alert every hour so DBA team can look into the usage of Tempdb on hourly basis. The sp gives info...

Thank you very much for your input. It worked for now..

Can you be more specific on the FOR XML thing

Thanks in Advance