Searching for a string that occurs more than once in syscomments.

[FatherTime]

I am having a problem that when searching syscomments for a string, to see if it occurs more than once in a SP or Trigger. I get the name of the SP or Trigger only once. If the string is found it moves on to the next Object and will not tell me how many time the string occured in a SP or Trigger. Eg: If searching through syscomments for '12345' and it occurs in SP1, SP5 and 3 times in SP8, I get SP1,SP5 and SP8 in my result set. I want SP1, SP5, SP8, SP8,SP8.
Does anyone know how to query syscomments to get this.
Thanks

 

[tlbroadbent]

Are you using Microsoft SQL Server? If you are I suggest posting your question in forum183, the MS SQL Server forum. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.