Hi,

I have taken CHAR(13) off from query now and still works, so the sql query looks like the below now:

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(10)

),8,8000)

--SELECT @SQL

EXECUTE sp_executesql @SQL