Look at SQL Programmer from Sylvain Faust int. It has a feature that can control version of stored proc like Visual SourceSafe. I do not work with it so I can not tell you if it is great or what, i just saw it in a VB magazine.
I am trying to find the internet adresse of their site but i can't put my finger on it. The minute that i find it i will write it down.