Cannot break at stored procedures from VC.NET 2003 -- visual studio .net debugging

Juan Dent
8/3/2004 1:17:01 PM

Nope, I can't make it work. And the article 32815 is for older clients (pre SP3 Query Analizer and Visual Studios previous to Visual Studio .NET.

So my problem is reopened. I cann't break into stored procedures. I get the following tip when I move the mouse to the text of the stored procedure in VS.NET 2003:

"The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded."

Any more ideas?

--
Thanks in advance,

Juan Dent, M.Sc.

[quoted text, click to view]

v-garych NO[at]SPAM online.microsoft.com (
8/4/2004 7:29:46 AM

Hi Juan,

Thanks for your response!

[quoted text, click to view]

That Knowledge Base Article(328151) also appies to the "Visual Studio .NET
Application Debugging", I suggest you test the following methods:

1. Enabled SQL Debugging within the project settings: Project's
properties/Configuration Properties/Debugging, make sure that Enable SQL
Debugging is set to True. This should load required symbols that would be
needed to step into stored procedures in any given debugging session.

2. Run the following SQL code: exec sp_sdidebug 'legacy_on' on the
Master database(this is due to the extra level of security that was added
in SQL SP3).

Thanks!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Juan Dent
8/4/2004 3:29:01 PM

Thanks again Gary. I don't what I did different before, maybe I executed
exec sp_sdidebug 'legacy_on'
on a database other than Master because I had followed everything else to
the detail.

Anyway, I now have my SQL debugging from VS.NET 2003 applications back and
working and you to thank for!!!

God bless.

[quoted text, click to view]

Geraldo Thomaz Jr.
11/24/2005 1:45:04 PM

I am having the same problem with VS2005 and SQL2005.
But when I executed exec sp_sdidebug 'legacy_on' on the master database but
I got the following message:

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_sdidebug'.

Can somebody help me?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about visual studio .net debugging

visual studio .net debugging : Cannot break at stored procedures from VC.NET 2003