Solved

Debugging SQL in VS 2010

Posted on 2014-07-31
8
162 Views
Last Modified: 2014-08-25
Hello Experts,
I am trying to debug Stored Procedure in Visual Studio 2010.   It doesn't Step Into my SP code at all.  I have Sql Server 2008 installed.  In the SP, the break points are looking odd.  Please see the picture and let me know what I am missing.  It was working before.  There is no known changes I did recently.  Thank you very much in advance.
SQL-Debug.png
0
Comment
Question by:RadhaKrishnaKiJaya
  • 5
  • 3
8 Comments
 
LVL 40
ID: 40232897
The fact that you see the breakpoints (red dots) does not mean anything is your are not in the proper environment and setup.

This can be due to many factors, but the most current ones are the followings:

- You are working with SQL Server Express. It does not support debugging.

- You did not activate SQL Server debugging in the Debug tab or your project's Properties window. In many solutions, the debugger must be activate in all the projects, even those that do not access the database.

- You do not have the debugger rights on the database.
0
 

Author Comment

by:RadhaKrishnaKiJaya
ID: 40232965
Thank you James!  I am not working on SQL Server Express version.  In the Project Property window, the SQL Debug is already checked.  Any other thoughts?  Thank you again!
0
 

Author Comment

by:RadhaKrishnaKiJaya
ID: 40233081
When hover the mouse to the break point I see this message "The breakpoint will not currently be hit. No symbols have been loaded for this document."
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 40
ID: 40233271
Then you have to rely on the sixty different possible solutions presented here and there. Here are a few links:

http://www.go4answers.com/Example/vs2010-breakpoint-not-currently-hit-26548.aspx
http://weblogs.asp.net/guybarrette/the-breakpoint-will-not-currently-be-hit
http://aspnet.4guysfromrolla.com/articles/051607-1.aspx

They are for older versions of Visual Studio or SQL Server, but the mechanism has not changed, so they should also apply to your environment.

Good luck
0
 

Author Comment

by:RadhaKrishnaKiJaya
ID: 40247924
James, I tried your links.  None of them worked for me.  Please let me know if you have any other ideas.  Thank you!
0
 
LVL 40
ID: 40247948
Just to be sure. I assumed that this was already set. Are you in Debug mode? Under the Advanced Compiler options of the Compile tab of the project's Properties window, is Generate Debug Info set to Full? Some of the debugger features that worked with pdb-only in previous versions of Visual Studio require Full in newer versions, and the change is not made automatically when you convert a project from one version to another.

Other than that, it's Google or Bing. The suggestions and links that I gave you ware the ones that worked for me in the past. As is unfortunately the case with such problems, there are many other solutions on the Internet. You might be able to find one that apply to your environment.
0
 

Accepted Solution

by:
RadhaKrishnaKiJaya earned 0 total points
ID: 40275356
I am sorry to say, none of the experts advise work for me.  I will go ahead and close this case.
0
 

Author Closing Comment

by:RadhaKrishnaKiJaya
ID: 40282655
This is not resolved yet.  Reason already described.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question