Hi,

Try:

set @sql = 'SELECT  Distinct(Table_Name) into #diff FROM ' +
           @DbName +
           N'.INFORMATION_SCHEMA.COLUMNS where DATA_TYPE in (''text'', ''ntext'', ''image'', ''timestamp'')';

Hope this helps.