>Is there a "Find" function when editing stored procedures. I'm used to Ctrl-F, but I can't find a way in Enterprise Manager and stored procedures.
>
>Thanks
>Kirk

Kirk,

this is search all store procedures for the string that you want. Also, I myself use Ctrl-F from Query Analyzer to open store procedures, but you can not use it from the Enterprise Manager.

select sc.text
from syscomments sc
inner join sysobjects so
on sc.id = so.id
where text like '% variable string you want to find %'

Hope this helps.

Carl