You could do this query without resorting to using sysobjects and sysindexes (use information_schema)

For example:

select table_name

from information_schema.tables

where table_name not in (select distinct table_name

from information_schema.columns

where data_type in('text','ntext','image')

or (data_type in('char','nchar','varchar','nvarchar')

and character_maximum_length=-1)

)