---

USE [myNewVasya];
GO

SELECT *
FROM dbo.spr_tipSend
WHERE CONVERT(nvarchar(max), (
    SELECT spr_tipSend.*
    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
)) LIKE N'%time%';

USE [myNewVasya];
GO

SELECT
    QUOTENAME(OBJECT_SCHEMA_NAME(m.object_id))
        + N'.' + QUOTENAME(OBJECT_NAME(m.object_id)) AS objectName,
    o.type_desc,
    m.definition
FROM sys.sql_modules AS m
JOIN sys.objects AS o ON o.object_id = m.object_id
WHERE
    OBJECT_NAME(m.object_id) IN
        (N'manyaCheck3', N'SendChannel')
    OR m.definition LIKE N'%otzyvLitTime%'
    OR m.definition LIKE N'%litletime%'
    OR m.definition LIKE N'%litlTime%'
ORDER BY objectName;

WHERE meropDt >= CONVERT(date, '20261013', 112)
  AND meropDt <  CONVERT(date, '20261014', 112)