That would be a good idea. Can you give me some of the output fields you'd like to be included / shown?

You should see some areas of code that look similar to the following (partial code example below):

CONVERT (VARCHAR (15), CONVERT (MONEY,

You should be able to get around the error by...

Unfortunately I don't work in an environment that uses partitions so I have nothing to test against. Not sure if I can help you any further. 🙁

Try this:

The line of the code which says:

DB_NAME (MF.database_id) AS database_name

Replace it with:

MF.name AS database_name

If that doesn't work, then try replacing it with:

REPLACE (RIGHT (MF.physical_name, CHARINDEX ('\', REVERSE (MF.physical_name))),'\','') AS...

Try adding one of these (think it should do the trick):

MF.name AS logical_database_name

or

REPLACE (RIGHT (MF.physical_name, CHARINDEX ('\', REVERSE (MF.physical_name))),'\','') AS os_file_name

Rememeber: You will need to update the @vXML_String and @vBody...

Great suggestions. For point 1 I noticed this as well but still wanted to see them for my purposes (plus they fall off the list as we do cleanups of...

Sorry, there is no 2000 version (and unlikely that I'll be making one).

Hmmm... would need to see the output. Send it to me if you want (email address is in the script).

Fantastic! Great to hear. 🙂

Thanks for the feedback. Sorry it can't help you though. 🙁

Can you give me some details such as what version of SQL Server you are using? Also, I know that if you are using some versions of IE that code...

My pleasure! 🙂

Glad you liked it and I hope it helps you out. 🙂

Yes, please do! 🙂

Gracias!