Easy (Maybe)

Is there a way to do a find on all stored procedures for text found within the stored procedure?

What ? :)

- jamie

Code:

---

SELECT name
FROM sysobjects
WHERE xtype='p'
AND name LIKE '%';

---

On the last line of SQL query substitute % for the text you are searching for. (% is a wild card...like * in DOS) This will return all stored procedures in the current database with names like you have specified.

I'm still workin on how to search the text contained within them...

Nah...I don't know where the stored procedures (or rather the text contained within them) is stored... so you'll just have to do with searching their names.