Extended event session on SQL Server 2014 to capture stored procedure calls and arguments passed
<p>I have an application which generates certain reports while values are entered and generate button is clicked on an application.</p>

<p>I know to which database this application is connecting, but don’t know which stored procedure is getting called. The database is having 100s of stored procedures. </p>

<p>So I need to track which stored procedure is called and what arguments are passed while clicking each button on the application.</p>

<p>Guys, please could you help me to create an extended event session which captures every stored procedure call with the arguments passed - in a specific database?</p>

<p>Thanks</p>

<p>JJ</p>