title: Linking tables between databases
body: <p>I’m after a bit of advice on the best way to go about this is SQL server 2008R2 express. I have a number of applications that are in separate databases on the same server. They are all “plugins” that use a central staff/structure list that will be in a separate database. The application is in the process of being migrated from JET.</p>
  
  <p>What I’m looking for is the best way of all the “plugin” databases being able to see the central database and use those tables in standard queries and views etc.</p>
  
  <p>As I’m using express that rules out any replication solution and so far the only option I can think of is to use triggers or a stored procedure to “push” out all the changes to the plugins. The information needs to be populated on a near enough real time basis however the number of changes will be very small maybe up to 100 a day and the biggest table only has about 1000 rows at the moment (the staff names table).</p>
  
  <p>Hopefully that will cover all everything but if anyone needs any more details then just ask</p>
  
  <p>Thanks</p>