title: Notification about Database Change
body: <p>I am trying a scenario in which I want to update my desktop UI running on different PCs with changes committed by any user. For example:</p>
  
  <ol>
  <li>Application1 is installed on PC1, PC2 and PC3.</li>
  <li>Assume all PCs are running this application.</li>
  <li>Say User 1 on PC1 changes the data and commit to the database</li>
  <li>the UI on PC2 and PC3 should be updated with changes without polling or pulling the data from the database.</li>
  </ol>
  
  <p>Can anyone suggest a way to notify my middle tier service about the database change which then I can relay it to all registered client. Will SQL Notification Services or Service Broker notify when the table is changed (inserted/updated/deleted)? Any suggestions will be helpful.</p>