December 8, 2003 at 8:18 am
Hi,
Is there any way to achieve the above?
eg, if i want to see all the user sprocs that contain the word "product", then at the minute I have to manually wade thru all my sprocs in EM.
not too clever, eh?
Is there a better way to do this thru sql or other?
cheers,
yogiberr
December 8, 2003 at 8:23 am
Something like this?
http://www.sqlservercentral.com/scripts/contributions/593.asp
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 8, 2003 at 8:23 am
select * from syscomments where text like '%product%'
December 8, 2003 at 8:31 am
.......
declare @criteria varchar(500)
set @Criteria = 'product'
select distinct name
-- optional text excerpt:
/*,replace('... ' + substring(text, (patindex('%' + @Criteria + '%',text) - 55), 155)
+ ' ...', @Criteria ,UPPER( @criteria )) as Excerpt*/
from syscomments M
inner join sysobjects O on O.Id = M.Id
where text like '%' + @Criteria + '%'
order by name
December 8, 2003 at 9:22 am
I did this recently .......
I just used Enterprise Manager to generate a SQL script for all SPs, but put them all to one file big on your C drive, then use wordpad's search to look for your test ... very simple.
December 8, 2003 at 11:05 am
hello, thanks all , for taking the time.
I appreciate it.
yogiberr
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply