visual studio - Debugging MS SQL Stored Procedure -
I have a problem debugging processed process to work in Visual Studio 2008: when I start debugging I get these success messages. Output window, although the actual stored procedure windows do not appear. Automatically engage with the process. [1640] [SQL] Stages 'machine' stages 'succeeded on the machine' thread 'stagscall [67]' (0xf80) code 0 (0x0) is. The thread has been removed from 'stagscall [67]' (0xf80) code 0 (0x0). The thread has been removed from 'stagscall [6 9]' (0x908) code 0 (0x0). The thread has been removed from 'stagscall [6 9]' (0x908) code 0 (0x0). The thread has been removed from 'stagscall [6 9]' (0x908) code 0 (0x0). The thread has been removed from 'stagscall [6 9]' (0x908) code 0 (0x0). Running [DBO]. [USPCGet XYZ] (@nLieferantId = 161616, @NatrucTurID = -1, NPG index = 1, @nPsSyzues = 16, @SSortort Column = Arlangnam, @ NSARASACD = 1).
The Visual Studio is found in 'Debug Mode' but the process is not fully visible.
The steps I took:
- SQL debugging enabled in project settings
- Open SQL Connection in Server Explorer
- On Connection Enable CLR / SQL Debugin
- Right-click on the process and select "Step in stored procedure"
Alternatively I tried to open the process and set There is a breakpoint here, it does not help.
Any thoughts? As is said, there is a connection, but the Visual Studio process is not able to open the code.
Any chance, do you have " performance real execution plan " ? I have found that if you click on that button then debugging will not work, although I can not understand why this will be the case for my life.
I have not submitted a bug on connect, but one would be happy to raise one if anyone knows about it.
Comments
Post a Comment