title: How to debug a trigger in SQL Server what is executed by an ASP Web app?
body: <p><strong>Context:</strong></p>
  
  <p>I have a (legacy) ASP.NET app using a class lib which's data access is calling SPs using ad  dal.dbml and its generated code. </p>
  
  <p>I am using VS 2015 Enterprise update 1, have locally installed Microsoft SQL Server 2014 - 12.0.4213.0 (X64)  (Build 10586) and SSMS 2014.</p>
  
  <p><strong>Question</strong></p>
  
  <p>When running the Web application the app inserts rows to a table which I recently implemented an insert trigger. How can I debug the actual trigger execution "triggered" by the Web application?
  Note: I do know how to interactively debug SPs in SSMS. Now that is not I want, because It is nearly impossible to reproduce and parametrize what the web app does. So I would like to debug via the Web App.</p>
  
  <p>Is this possible at all? (Seems to be a pretty usual need, though I unserstand it requires very complex debugging infrastructure and services)</p>