You can search text in syscomments table like so:
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%UKSQL01%'
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho