?
Solved

Debugging SQL in VS 2010

Posted on 2014-07-31
8
Medium Priority
?
167 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

777 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