Debugging SQL Server Stored procedure help

[David C. Allen]

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!

[David C. Allen]

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!