Solved

Debugging SQL in VS 2010

Posted on 2014-07-31
8
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

688 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