How do I parse the xml part of a database mail to a table?
I have created a database mail solution. The data portion of each email is stored as xml in the msdb table. How do I write a stored procedure that will parse the data to a table. I need this feature to enable the auditors to view the archieved items. SQL 2005