We have an application that has multiple identical databases apart from customer customizations. we would like to centralize the stored procedures that are common across all databases. Currently, we are having problems with keeping all databases up to date as customizations are done in the common database.
We have tried to make some customer-specific stored procedures which are called from our "Global" stored procedures. This works as long as all the people that have access to the database adhere to the rules. But as with all rules the bosses do not follow them. :(
So i would like to make a stored procedure truly Global that is executed from a central location and not the individual database.
I have already tried storing stored procedures in a central database and then have a job copy them to all databases. this resulted in some seriously pissed-off bosses. :(
Anybody have some good ideas for this?