can we debug store procedure?

Question

Hello all I used stored procedures for Crystal reports. There are many changes as per the client requirements. Can we debug store procedure as we debug project in VS ? Please help. Regards Zuber Kazi

Kumar Saurabh · Answer

Zuber - I have tried debugging Stored Procedure using Visual Studio. 1)From the VS menu -> Go to Views -> Server Explorer. 2)Connect your SQL Server database. 3)Open your Stored Procedure. 4)Set the breakpoint. 5)Alt + F5 => to Step into the opened Procedure. 6)F11 - and the usual debugging works. Find attached the Screenshot. Let me know if it helps.