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

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -