Searching through Stored Procedures

[DeadManWalking]

Does anyone know of a easy way to search through SPs?

We added a new product to our data entry program but some of my fellow programer(which I'm still yelling at) did not keep a list of stored procedures that he changed. So now I have to go through 300+ SP's to see which ones I need to move over to the live server. If there is a way to search for a string(='Rov') inside the stored procedures that would be great.

Thanks

[andi_g69]

Try the script found at:

http://www.databasejournal.com/scrip...le.php/1493141

[MAK]

1. script all procedures and download to a folder and do a search (start-search- file or folders-containing text)

2. you can download SQLCompare trial version and do a search.

3. whomever you are yelling at did a drop and recreate on procedure instead of alter, you can find the crdate column in sysobjects table will be useful.

[DeadManWalking]

Thanks for the suggestions. I'll check on that script and see how that works.

Mak, sadly he did an alter so I guess that ideas out. I am currently going through the script file put like I said 300+ Sp's so its been fun Thanks though