>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
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,