Debug SQL stored procedures in VS2010

Question

I am trying to debug a stored procedure in VS2010 using the server explorer and the menu command "Step into the stored procedure".

The problem that I am facing is that when I right-click on a stored procedure, the only parameters that I have are Copy, Refresh and Properties. Is there anything I need to do so that the option "Step into the stored procedure" appears?

• SQL debugging is included in the project properties for a good evaluation.
• This option is available in my vs2005 installation.

Answer 1

You must add the server / database in Visual Studio 2010 Server Explorer .

.

Answer 2

VS10 Pro MsSQL10R2 MsSQL, Server Explorer, VS10 , , SP. SP, , .

MsSQL SP , Query Analyzer, , .

VS10 MsSQL9 , , SQL, "" , SP. PL/SQL script, SP, .

( , WAG: , , , , , , .)

Answer 3

Have you tried to execute the script stored procedure and open the sql file on local or SQL Server using Management Sudio? You will be able to set several PRINT flags and debug according to your needs. Hope this workaround works!

Answer 4

verify that you are using the data provider: ".Net Framework for DataProvider for SQL Server"