VS.Net Stored Proc debugging

Posted on 2003-03-27
Medium Priority
Last Modified: 2012-06-21
I follow the steps from
http://support.microsoft.com/default.aspx?scid=kb;[LN];316549 to debug stored procedures from VS.Net 2002 Enterprise Architect (with a local SQL Server 2000 SP3 ON XP Pro SP1) .

I follow the steps of Option 1 and it executes exactly like it is written.

I follow the steps of Option 2 and ... it doesn't work!

When I start the application, I can see a white question mark on the breakpoint of the Stored Proc. The tooltip say:
"The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint is not loaded."

Any ideas?
Question by:Éric Moreau
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
LVL 70

Author Comment

by:Éric Moreau
ID: 8220468
Your article is too old. It talks of VB6, SQL7, ...

Dianne (the author of the article) as written an update of this article in the Visual Studio Magazine of November 2002 and it doesn't give me more hints.

The strange thing is that I can step through stored proc from the Server Explorer but not from the code!
LVL 28

Expert Comment

ID: 8220522
Maybe this will help

To debug TSQL, the user
should have the permission on the database to execute SP_SDIDEBUG stored
procedure. The default access is for sa only. In addition, mssdi98.dll
should be installed in the Binn directory of the SQL Server.

The followings are the step to grant the permission.
1) Use SQL Enterprise Manager to open the Master database (if you have
permissions to do so)
2) Look for sp_sdidebug under "Extended Stored Procedures"
3) Right click and click Properties and then Permissions
4) Check the Exec box for each account that should have rights to debug SPs.
Congratulations! You’re Certified – Now What?

Starting a new career can be overwhelming. Becoming certified in your field of expertise is a great start, but where do you go from here?  Here are some tips to help you on your career journey.

LVL 70

Author Comment

by:Éric Moreau
ID: 8220618
I appreciate your help.

-Access have already been granted to SP_SDIDEBUG to the Public role and I am "System Administrator".

-I have 3 versions of mssdi98.dll. I have tried them all without success.
LVL 70

Author Comment

by:Éric Moreau
ID: 8224589
I found it!!!

It is related so SP3 (of SQL Server).

This is stated in "INF: T-SQL Debugger Is Turned Off By Default for Earlier Clients After You Install SQL Server 2000 Service Pack 3" from http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328151 :

Microsoft has disabled T-SQL Debugger for earlier clients for security reasons. To enable T-SQL Debugger for earlier clients, a member of the sysadmins server role, such as sa must explicitly enable debugging by running the following code:
Exec sp_sdidebug 'legacy_on'

You must repeat this procedure whenever you restart the server. Microsoft does not recommend that you use T-SQL Debugger on a production server.

Now I need to find a way of automating this thing! I think I will write a small .sql file and use OSQL to run it every time I start my computer!
LVL 70

Author Comment

by:Éric Moreau
ID: 8224593
I will ask for a refund and send to PAQ. Any objections?

Expert Comment

ID: 8235998
A request for deletion has been made.  If no response or you feel this is in error, comment.  If no objection, I will delete in three days.

E-E Admin

Accepted Solution

SpideyMod earned 0 total points
ID: 8272749
PAQ'd and all 250 points refunded.

Community Support Moderator @Experts Exchange

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

741 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