If they are on the same server then why do you want separate databases
per country? As Simon has said, you could just add the country as part
of your primary keys. If you do have to take the separate databases
route then you probably won't gain much from putting the SPs in one
central DB. It would just add to code complexity unless for example you
created separate views in your master db that pointed to the correct
database, or maybe a set of partitioned views... which again begs the
question, why separate DBs?

--
David Portas
SQL Server MVP
--