I have feedback regarding Ctrl-0 to search for a phrase in an object's script. I have something I've been running to do that as well, but it uses sys.sql_modules instead of sys.comments:
select distinct db_name(), o.name
from sys.sql_modules m (nolock)
inner join sys.objects o (nolock) on m.object_id = o.object_id
where m.definition like '%SomeText%'
The comment I incorporated at the top of the script explains why:
-- Use sys.sql_modules because all the procedure's contents are stored
-- in one row. syscomments only holds a maximum of 8000 characters
-- and will split the code into multiple rows if it goes over 8000
-- and your search string may get split in the process.
Just sharing in case you had any thoughts?