Multiple Database And Central Libraries

I have a question about MS sql 2000 and hope someone can give me a hand though this may not be the most suitable place to post.





I have created multiple databases storing multi-country data. Tables and store proc in each db are exactly the same except they are placed and run in different dbs in runtime.





My question is:


Is it possible to centralize all the store proc and function into a central db (or a dummy db) for easy maintenance but it allows us to point to the desired database environment in runtime even I run the store proc in central database.





I find the "Use database" command but it does allow us to use it in store proc. Any advice or suggestions???





Thanks in advance


bryan