title: How to trace a call to a stored procedure and get feedback out of its execution?
body: <p>I have a stored procedure that I'm calling from asp.net and I'm adding 47 parameters mostly from values selected on drop downs and radio buttons and text boxes from a form. I also have (for some reason beyond my pay grade) some parameters that are set to Null..these are also a source of some hair pulling and I don't know if these are the problems or not. </p>
  
  <pre><code>Dim Parameter As SqlParameter = New SqlParameter("@type", "u")
  Dim Parameter1 As SqlParameter = New SqlParameter("@user", User)
  Dim Parameter2 As SqlParameter = New SqlParameter("@term", terminal)
  Dim Parameter3 As SqlParameter = New SqlParameter("@url", accesslevel)
  Dim Parameter4 As SqlParameter = New SqlParameter("@name", firstname &amp; " " &amp; lastname)
  Dim Parameter5 As SqlParameter = New SqlParameter("@mgr", mgr)
  Dim Parameter6 As SqlParameter = New SqlParameter("@mgrEmail", mgr)
  Dim Parameter7 As SqlParameter = New SqlParameter("@phone", mgr)
  Dim Parameter8 As SqlParameter = New SqlParameter("@title", titletitle)`
  
  ... and on and on until Parameter48...
  
  Dim myCommand As New SqlCommand("dbo.proc_vsSpacAccess", conn)
  myCommand.CommandType = CommandType.StoredProcedure
  
  myCommand.Parameters.Add(Parameter)
  myCommand.Parameters.Add(Parameter1)
  myCommand.Parameters.Add(Parameter2)
  myCommand.Parameters.Add(Parameter3)
  myCommand.Parameters.Add(Parameter4)
  ... and on until Parameter48... and then finally I run the stored proc..
  
  myCommand.ExecuteNonQuery()
  </code></pre>
  
  <p>end of subroutine...</p>
  
  <p>I run this and get nothing, no feedback, nothing. How do I know what's wrong if things aren't working? do I debug from SQL Server (<strong>I can't change the stored procedure it's not mine to change btw</strong>) or try to debug the stored procedure from Visual Studio?</p>
  
  <p><strong>I REPEAT, I CANNOT CHANGE THE STORED PROCEDURE IT IS READ ONLY FOR ME..</strong></p>