---

USE [exos9300];
GO

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql = @sql +
N'SELECT ''' + s.name + '.' + t.name + ''' AS [Таблица],
         ''' + c.name + ''' AS [Столбец],
         ' + QUOTENAME(c.name) + N' AS [Найденное значение]
  FROM ' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) + N'
  WHERE ' + QUOTENAME(c.name) + N' LIKE N''%Гришаева%''
     OR ' + QUOTENAME(c.name) + N' LIKE N''%Grishaeva%''
  UNION ALL
'
FROM sys.tables t
JOIN sys.schemas s ON t.schema_id = s.schema_id
JOIN sys.columns c ON t.object_id = c.object_id
JOIN sys.types ty ON c.user_type_id = ty.user_type_id
WHERE ty.name IN ('varchar', 'nvarchar', 'char', 'nchar');

-- убираем последний UNION ALL
SET @sql = LEFT(@sql, LEN(@sql) - LEN('UNION ALL' + CHAR(13) + CHAR(10)));

EXEC(@sql);