This should work
SELECT OBJECT_NAME(c.object_id), c.name, t.name
FROM sys.columns c
INNER JOIN sys.types t ON c.user_type_id = t.user_type_id
WHERE t.name IN ('text','ntext','image','xml')
OR (t.name IN ('varchar','nvarchar','varbinary') AND c.max_length = -1)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability