Search a string in all stored procedures / Triggers

[parbhani]

Hi Guys ,

I am on ASE 12.5 on Solaris.

I want to search a string in all the stored procedures and triggers in a database, how can I do that ??

Basically, in one of our tables a column is being updated by a string say 'FUNNY', I want to know from where that is happening ??

Please help.

Regards

 

[mjuell]

I think this will work:

declare @database varchar(30),@searchstring varchar(128)

select @database = 'xxx'
select @searchstring = 'hello'

exec ( "select so.name,count(*) from " + @database + "..syscomments sc1," + @database
+ "..sysobjects so where sc1.text like '%" + @searchstring + "%' and so.id=sc1.id group by so.name")