SELECT 
	[s].[name] + '.' + [t].[name] AS TableName
FROM [sys].[tables] AS t
INNER JOIN [sys].[schemas] AS s
	ON [t].[schema_id] = [s].[schema_id]
WHERE EXISTS
(
	SELECT 1 FROM [sys].[columns] AS c1
	WHERE [c1].[object_id] = [t].[object_id]
	AND [c1].[max_length] = -1
	AND [c1].[system_type_id] IN 
	(
		165, -- VARBINARY
		167, -- VARCHAR
		231  -- NVARCHAR		
	)
);