title: Monitor SQL database changes
body: <p>I have two applications, each with their own SQL DB's.  I have no control over the applications themselves, but I do have access to the databases.  </p>
  
  <p>What I'm looking to do is, when there is a change to the data for certain tables in App1, I need to either insert/update this data in the App2 database.  This needs to be done in a 'live' scenario and <strong>not</strong> by polling periodically.</p>
  
  <p>Currently I have done this using triggers, but I would like to consider some alternatives.  I don't know if it is possible to create some sort of C# application which constantly runs in the background as a windows service or the like that monitors for changes.  The minimum SQL Server to support is 2005.</p>
  
  <p>Any help or suggestions are greatly appreciated.</p>
  
  <p>Thanks</p>