---

USE [exos9300];
GO

DECLARE @sql NVARCHAR(MAX) = '';

SELECT @sql = @sql +
'IF EXISTS (
    SELECT 1
    FROM ' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) + '
    WHERE ' + QUOTENAME(c.name) + ' LIKE N''%Гришаева%''
       OR ' + QUOTENAME(c.name) + ' LIKE N''%Grishaeva%''
)
PRINT ''' + s.name + '.' + t.name + '''
'
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');

EXEC(@sql);