I mark my SQL with a 'Todo' symbol whenever I decide something needs work, but I don't have the time to do it right away. So I wrote this usp so that I can get a quick list of stored procedures, function and views that need some extra work.
It also comes in handy whenever you have to find a certain character sequence. I had to find everything with '365' in it cause one of my clients liked to hardcode certain values. 🙂
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.