More simplified form:-)

SELECT '['+SCHEMA_NAME(SCHEMA_ID)+'].['+name+']' TableName

FROM Sys.tables WHERE name NOT IN (

SELECT Distinct ic.TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS ic

INNER JOIN Sys.tables st ON ic.TABLE_NAME=st.name

WHERE ic.DATA_TYPE IN('text', 'ntext', 'image')

OR CHARACTER_MAXIMUM_LENGTH = '-1')