Yes I do it manually. Updating lots of objects is tedious, but there are a few tricks.
1. Naming conventions. Keeping all objects named according to some rule makes things simpler.
2. I always have VSS and QA running. They are both set to work with the c:\sql folder, so things are in one place.
3. Use the search features of VSS. If I need all stored procedures that reference the "Products" table, I search for them and then check out all the items that are found.
I have probably 1000 objects on my main server and I make changes very quickly. Week to week, I am working with only a dozen or so and I use the method in my new article to track changes. That way I know which objects I need to work on.
Steve Jones