Updating multiple versions of a Stored Procedures

Hi everyone,

I have a task that I need some help with. I am designing an ecommerce site building tool using ASP.NET, C#, MS SQL etc. I am designing the system entirely in components so updating/bug fixing can be done with minimal effect on the rest of the system. The idea is that it will be easy to update multiple running copies of the same application (for different online stores) just by replacing old components with changed components for each seperate copy of the application. It would be easy to run an automated task to update the separate applications. Any changes in database structure could also be implemented automatically through code. The problem i have is in determining some sort of automated way of updating stored procedures in a MS SQL database. If a change needs to be made to a stored procedure and there are 400 copies of the application running, that means 400 manual updates!!!! Is there any simple way anyone can think of doing this efficiently? i.e. would it be possible to write some sort of administration tool to rapidly update the stored procedure but in multiple MS SQL databases?

I hope i have made sense here!

Thanks,

Andrew