DECLARE @ObjectName NVARCHAR(200) = 'Testo_da_Ricercare'

-- Cerca il testo nelle Viste

SELECT 
    OBJECT_NAME(OBJECT_ID) AS ViewName
FROM 
    sys.sql_modules
WHERE 
    definition LIKE '%'+@ObjectName+'%'
    AND OBJECTPROPERTY(OBJECT_ID, 'IsView') = 1

​​​​​​​-- Cerca il testo nelle Stored Procedures
    SELECT 
    ROUTINE_NAME
FROM 
    INFORMATION_SCHEMA.ROUTINES
WHERE 
    ROUTINE_DEFINITION LIKE '%'+@ObjectName+'%'
    AND ROUTINE_TYPE = 'PROCEDURE';

-- Cerca il testo nei comandi SQL dei passaggi dei Jobs
SELECT J.name AS JobName, S.step_name AS StepName, S.command
FROM msdb.dbo.sysjobs J
JOIN msdb.dbo.sysjobsteps S ON J.job_id = S.job_id
WHERE S.command LIKE '%'+@ObjectName+'%'