title: Debugging stored procedure in SQL Server Management Studio (using context menu debug stored procedure
body: <p><a href="https://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx</a></p>
  
  <p>From the above link, it seems it is possible to debug a stored procedure in SSMS.</p>
  
  <p>I am accessing a SQL Server instance using SQL Server authentication with admin privileges. I want to debug a stored procedure in SSMS, but I don't get that option. </p>
  
  <p>Somebody told me that it works only with Windows authentication (while connecting to the database). I don't know to what extent this is true.</p>
  
  <p>What are the prerequisites for allowing to debug a stored procedure? Because in deployment, stored procedure might have 50k lines and it would be hard to debug by print selective statement to get the clue and all (workaround). </p>
  
  <p>Following are true in my case:</p>
  
  <ol>
  <li>SSMS is professional edition.</li>
  <li>SQL Server user for accessing is admin user</li>
  </ol>
  
  <p>(IMHO, there needs to be a way to debug a stored procedure with SQL Server authentication mode too).</p>
  
  <p>So, I would really appreciate, If someone can take me through that process</p>