Hi, I have amended your code so that all appears in one select statement.

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = substring(REPLACE(

CAST(

(

SELECT ' UNION SELECT * FROM ' + QUOTENAME(name)

--Select *

--'SELECT * FROM '+ QUOTENAME(name)

+'.'+'INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like ''FindMe'''

FROM sys.databases

FOR XML PATH('')

)

AS NVARCHAR(MAX)

),

' ',CHAR(13) + CHAR(10)

),8,8000)

--SELECT @SQL

EXECUTE sp_executesql @SQL