Here's a shotgun. It has the potential to bring your server to it's knees, so don't even think about running this anywhere near a production server.

DECLARE @SQL AS VarChar(5000)

SET @SQL = ''

SELECT @SQL = @SQL +

'SELECT * FROM [' + t.TABLE_SCHEMA + '].[' + t.TABLE_NAME +'] where cast(['

+ c.COLUMN_NAME + '] as nvarchar(4000)) = '''' '

FROM INFORMATION_SCHEMA.TABLES t, INFORMATION_SCHEMA.COLUMNS c

where t.table_name = c.table_name

and is_nullable = 'no'

and collation_name is not null

EXEC (@SQL)