I am trying to debug a Stored Procedure from Visual Studio 2013. I have already done the followings. When tried to Execute the code, the break points works in C# code. But in the SP the Break Point displays the message "the breakpoint will not currently be hit...", and never goes there. Please let me know if I am missing anything.
Under View --> Server Explorer --> Added the Database. Picked the Stored Procedure and added the Break Points. Also added the Break Point in the C# code in VS.
Thank you very much in advance.