Solved

Debugging SQL in VS 2010

Posted on 2014-07-31
8
164 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
edit .asp files 5 30
Add a Condition in ASP Repeater 6 34
Finding Events logs for IIS website that restarts 2 14
SQL - format decimal in a string 5 38
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…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 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