I wonder if there is a solution for this in SQL 2000 (or do I have to
wait for SQL 2005)?

I am currently in the middle of developing a 'Yahoo' style portal which
will be rolled out in about 20 or so countries. I have set up in SQL
Server one database per country. All the portals have the same
functionality - but show different data.

Is it possible to have a single database which holds stored
proceedures, functions and views and have the individual country
databases use these?

Note: I want to avoid using EXEC sp_executesql.

I look forward to some good news on this! Thank you in advance.

Dadou.