Debugging T-SQL Stored Procedure from running VS-Application

Hot Topic

LocalReport Error - A data source instance has not been supplied for the data source
Cannot Implement Splash Screen.
Cannot get EventSetter to work
Deploying Outlook Add-In (after following tutorial Part 2)
Indent Style
Properties on Relationship
"Keep-Alive and Close may not be set using this property"
How to edit the Oultlook default folders's name?
MSBuild vs NAnt
Debugger not stepping into my program

Visual Studio

jumping ListBox
"Office document customization is not available" error
Dynamic IP
Can someone give me an example of how to set an image?
design question regarding generated proxy classes/DataContracts
LINQ for compiling cool... but what about dynamic queries at runtime?
VS2005 installation on Vista beta1
No data in Reports, but the headers show up fine
Need to move VSS database with WEB project.
Extending the server explorer

Debugging T-SQL Stored Procedure from running VS-Application

Hi,

I know, that I can step into a stored procedure, and debug it from within visual studio. But I haven't figured out yet, how I can get Visual Studio to stop at a break point, when my actual *project code* called this stored procedure, so that I can see what parameters my program passed to the SP.

I suppose, I have to attach the T-SQL-debugger somehow (But I don't really know).

Does anybody know, how that works

Thanks,

Klaus

Answer this question

Debugging T-SQL Stored Procedure from running VS-Application

  • AndyWawa

    Thanks Habibh - I looked for exactly that, but obviously at the wrong place! ;-)

    - Klaus

  • Fuzzier

    You need to enable SQL debugging in the project properties. Open the Project Properties for you project and check the "Enable SQL Server debugging" under the Debug tab.

    HabibH.
  • Debugging T-SQL Stored Procedure from running VS-Application
Answer this question