title: SQL Server service broker and SqlDependency
body: <p>I have a system where my TCP/IP command prompt application receive data and insert that data in <code>[database1].[mytable]</code></p>
  
  <p>Now I want to move that data from <code>[database1].[mytable]</code> to <code>[database2].[anothertable]</code> when any new record insert in <code>[database1].[mytable]</code> without losing any single data. </p>
  
  <p>And there are a approx 70/100 records inserted every second into <code>[database1].[mytable]</code>. I want to move that data and have to do some calculation and then insert into <code>[database2].[anothertable]</code>.</p>
  
  <p>I have tried triggers and stored procedures as well but it take too much database memory though sometime my db hangs when there are concurrent user try to connect. </p>
  
  <p>So I have read and come up with solution like SQL Server service broker and <code>SqlDependency</code> with a C# application. </p>
  
  <p>My questions is: can I rely on SQL Server service broker or <code>SqlDependency</code> to achieve this? Because I do not want to lost/drop my any data as this are very important data. </p>
  
  <p>Any suggestions? </p>