Hi,

Not sure why the Where is in there, thought I had removed that already, obviously not!

a CTE would be fine to hold the table names, but this runs just fine...

Thanks, this is actually a very old revision which has since been revised.

please see the revised version:)

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

USE [Master];

SELECT mdsd.Name AS 'Database Name'

, dmes.Host_Name AS...