title: SQL Server : How to track changes value in a column and send notification email for only changed values
body: <p>I have a table as below that contains dealer codes and status. Every night between 1 and 6am  the status column may change for each dealer code. For example today the status of <code>00141.00062</code> is <code>operational</code>, but tomorrow it will be <code>deactivated</code> if the store was closed.</p>
  
  <p>Briefly,I would like to track the changes using by stored procedures and send a notification email to me just for the updated values.</p>
  
  <p>Lastly, I do not prefer to create a trigger cause of according to my previous experience it will be affect my main app. Therefore, I will be aprreciate if you can explain how I can do it via stored procedures.</p>
  
  <pre><code> DEALER_CODE    STATUS
   ----------------------------
   00141.00062    OPERASYONEL
   01033.00061    DEACTIVE
   00070.00002    DEACTIVE
   00524.00002    DEACTIVE
   00387.00020    DEACTIVE
   00543.00001    DEACTIVE
   00310.00061    DEACTIVE
   00247.00062    OPERATIONAL
  </code></pre>