Debugging SQL Stored Procedures in SQL 2005
Posted on 2010-09-02
I used to utilize this feature a lot in 2000 but have never used it in 2005. Can anyone give me step-by-step instructions for doing so please? I need to step into the SP on the server from a VB.net WinForms app on my client computer in Visual Studio 2008 Professional edition.
Currently the breakpoints in the SQL stored procedure are hollow circles with the message "the breakpoint will not be currently hit" "no symbols have been loaded for this document".