Best way for maintaining a master table for use in several databases

2005-09-27 Thread Neven Luetic
Hello, I have a database scheme, containing a table, whichs content should be unique across all databases with this scheme (on several servers as well). It would be possible to define one database, in which all changes would be made. But what's the easiest way to keep the table consistent in

Re: Best way for maintaining a master table for use in several databases

2005-09-27 Thread SGreen
Neven Luetic [EMAIL PROTECTED] wrote on 09/27/2005 05:02:58 AM: Hello, I have a database scheme, containing a table, whichs content should be unique across all databases with this scheme (on several servers as well). It would be possible to define one database, in which all changes

Re: Best way for maintaining a master table for use in several databases

2005-09-27 Thread SGreen
Neven Luetic [EMAIL PROTECTED] wrote on 09/27/2005 09:35:04 AM: Within a single server, you only need one copy of a table in one database. When you need data from it, just use the table's fully-qualified name and it won't matter which other database you are currently in (assuming that