• Another way would be to use the following code

    DECLARE @SQL NVARCHAR(MAX)

    SELECT @SQL =

    REPLACE(

    CAST(

    (

    SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

    'EXECUTE schema.procedure;'+CHAR(13)+CHAR(10)

    FROM sys.databases WHERE name NOT IN ('master','msdb','model','tempdb')

    FOR XML PATH('')

    ) AS NVARCHAR(MAX)

    ),

    '& # x 0 D ;',CHAR(13) + CHAR(10)

    )

    --SELECT @SQL

    EXECUTE sp_executesql @SQL

    just remove the spaces between '& # x 0 D ;'