I would like to write a DTS or some sql that will iterate through each proc in the database, find and replace a string, and then save the sproc out again using ALTER.
This is a big job that needs to happen in a short space of time so looking to automate the process, rather than outputting a script from all the sprocs, finding and replacing in a text editor and then running.
Question is how do I read in the sproc contents as a string? I've been poking around and know it can be done, but can't finding the missing part of the puzzle. Can anyone shed some light?
Sorry down to my last points at the moment.