Can't get VS2005 to step into T-SQL stored procedure for debugging!

Help! I've tried and tried, but I can't get VS2005 to step into T-SQL stored procedure for debugging! I've attached to a server and connected to a database, I right-click on a stored proc and choose "Step Into Stored Procedure", it opens the parms window and I supply the parms, but when I click to proceed, it just runs the proc without opening the code and without allowing me to step into it. It is VERY frustrating. PLEASE PLEASE PLEASE help me!

Bob




Answer this question

Can't get VS2005 to step into T-SQL stored procedure for debugging!

  • Tuppers

    Try to run sp_sdidebug 'legacy_on' in your query analyzer. I fixed my stored procedure debugging by doing it.

  • Juliano.net

    Same issue for me, and none of the other posts / article I've seen have worked.

  • Can't get VS2005 to step into T-SQL stored procedure for debugging!