You can simply check who deleted the data using SSMS: 1. Connect to the instance and right click 2. Click Reports >> Standard Reports >> Schema Changes Report 3. You will receive a pop up of Schema Changes History which will show the name of the user who deleted thee records.