title: How to track the login details in SQL Server who deleted the data
body: <p>I came across a weird situation in SQL Server db. I see few developer are randomly deleting/updating the data over multiple tables. Is there any mechanism exits in SQL Server to capture all information like who deleted the records or who updated the records ext?</p>
  
  <p>Details:</p>
  
  <pre><code>Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
  Copyright (c) Microsoft Corporation
  Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; 
           (Build 7601: Service Pack 1) (Hypervisor)
  </code></pre>