469,294 Members | 1,943 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,294 developers. It's quick & easy.

Debugging SQL Server Stored procedure help

I am trying to debug an SQL Server Stored Procedure form VS.NET 2003. I have
a break point set in the SP code but it is not being hit. When I hold the
pointer over the line it says that it will not be hit because:

Unable to bind SQL breakpoint at this time. Object containing breakpoint not
loaded at this time.

I am admin on this machine that also has SQL server on it. Any ideas on how
to fix this?

Thanks!
Jul 21 '05 #1
1 1661
Solved my own problem. I had to turn on debugging on my sql server via:

exec sp_sdidebug 'legacy_on'

"David C. Allen" <da*****@avci.net> wrote in message
news:#v**************@tk2msftngp13.phx.gbl...
I am trying to debug an SQL Server Stored Procedure form VS.NET 2003. I have a break point set in the SP code but it is not being hit. When I hold the
pointer over the line it says that it will not be hit because:

Unable to bind SQL breakpoint at this time. Object containing breakpoint not loaded at this time.

I am admin on this machine that also has SQL server on it. Any ideas on how to fix this?

Thanks!

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by CD | last post: by
3 posts views Thread by kd | last post: by
2 posts views Thread by rodchar | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.