• I just used this yesterday, if you're ever in the market for a quick select:

    sp_MSForEachDB @command1='USE ?;

    SELECT

    Table_Catalog

    ,Table_Schema

    ,Table_Name

    ,Column_Name

    ,Data_Type

    ,Character_Maximum_Length

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE DATA_TYPE = ''NVARCHAR'' and COLUMN_NAME like ''Recall%'' and TABLE_NAME LIKE ''%SAMPLE%'''