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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kumar SaurabhPosted Nov 19, 2012, 1:42 PM
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.