Debugging SQL Server Stored procedure help

D

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!
 
D

David C. Allen

Solved my own problem. I had to turn on debugging on my sql server via:

exec sp_sdidebug 'legacy_on'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Column Name Sql-Error :Executing a stored procedure 1
.net 2003 - debug stored procedure ok on 2k - but ? on XP at breakpoint. 1
Database Projects - Debugging SPs 2
debugging an SQL Server 2000 stored procedure... 1
SQL Server Stored Procedure timeout 3
Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Debugging 2
Unable to hit breakpoint Mixed mode debugging C# SQL 2

Top