• This should get you started.

    DECLARE @strSQL VARCHAR(max)

    DECLARE @dbaseName VARCHAR(255)

    DECLARE proplist CURSOR local static forward_only read_only FOR

    SELECT name

    FROM sys.databases

    WHERE database_id NOT IN ( 1, 2, 3, 4 )

    OPEN proplist

    FETCH next FROM proplist INTO @dbaseName

    WHILE @@fetch_status = 0

    BEGIN

    SET @strSQL = 'use [' + @dbaseName

    +

    ']; if not exists (select * from sys.extended_properties) select '''

    + @dbaseName + ''''

    EXEC (@strSQL)

    FETCH next FROM proplist INTO @dbaseName

    END

    CLOSE proplist

    DEALLOCATE proplist