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')