Ok, found a kind of solution that helps me.

as part of solution 1 per the above, I have found a brilliant site with all the XML knowledge i needed...

unfortunatly that's not an option for me. I'm still looking for a solution in SQL...

thx

thx Gianluca

your way is more elegant as i can see the object names.

thx Sam,

however, i believe i found the method to do this on my own.

select * from sys.all_sql_modules

where [definition] like '%mystring%'

Thank you very much guys, much appreciated. 🙂

i dont know if there's a solution for this within SQL (pretty new at the sql thingy myself). but what i would do in a situation like this is connect...