Update Data Among Databases

Hi,





I develop ASP.NET applications and use MS SQL 2000 Enterprise.





Each customer has one database and one custom design application. And, there is a gateway and a central database to get data from all databases.





Supposed there are 10 DBs. I want the data in those 10 databases updating to the central database directly.


So, the gateway can gather all data of 10 DBs from a central DB.





Now, my question is how should I do it in MS SQL 2000? Can I do it with a stored procedure (SP)? If so, how does the SP like?





Or, SP can only perform on it's own DB, but not execute across DBs? If so, how can I do that?





Thanks for advice