I wrote this a while back. Some said it did not work for them, but I don't know why. I am guessing user error.

Either way. It worked...

Check your "Messages" tab after it has run. It outputs a report to that tab. (Though if you db is error free then it will do "nothing".)

Vaccano

I saw this post as I was looking for a solution to do just this.

Sprocs can get out of date when the tables they use are changed after the sproc...