DECLARE @Search varchar(255)
SET @Search='ItemChangesLog'
SELECT DISTINCT
LEFT(so.name, 100) AS Object_Name,
"object_type"=left(
case so.type
when 'U' then 'Table - User'
when 'S' then 'Table - System'
when 'V' then 'Table - View'
when 'TR' then 'Trigger'
when 'P' then 'Stored Procedure'
when 'C' then 'Constraint - Check'
when 'D' then 'Default'
when 'K' then 'Key - Primary'
when 'F' then 'Key - Foreign'
when 'L' then 'Log'
when 'R' then 'Rule'
when 'RF' then 'Replication Filter stp'
else '<
end -- case so.type
,25)
FROM syscomments sc
INNER JOIN sysobjects so
ON so.id = sc.id
WHERE
text Like '%'+@Search+'%'
ORDER BY
2,1
.png)