asked on Is it possible to debug a Store Procedure on MSSMS after a unitTest that calls it from VS ?
Hello everyone,
I know how to debug a storeProc in MSSMS by launching the sp call from mssms with a breakpoint in it.
I know how to debug in VS.....
but i dont know how to use both at the same time :
Is it possible to launch debug for a unittest that call a SP and have MSSMS that take over with the debug and get back to VS ?
If it's possible how can i do that ? i would appreciate a recipe or a link to it.
thank you in advance.
toshi
I know how to debug a storeProc in MSSMS by launching the sp call from mssms with a breakpoint in it.
I know how to debug in VS.....
but i dont know how to use both at the same time :
Is it possible to launch debug for a unittest that call a SP and have MSSMS that take over with the debug and get back to VS ?
If it's possible how can i do that ? i would appreciate a recipe or a link to it.
thank you in advance.
toshi
Microsoft Visual StudioMicrosoft SQL Server.NET ProgrammingProgramming
Last Comment
Mark Wills
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you Mark !
toshi_
toshi_
A pleasure, and thank you very much for your question :)
Cheers,
Mark Wills
Cheers,
Mark Wills
My long answer is (what I have always done) to edit the stored procedure to write a log. Then go through the log after the event.
My humble answer is... Not as far as I have ever needed to (use edit and write log). But, according to https://support.microsoft.com/en-au/help/316549/how-to-debug-stored-procedures-in-visual-studio-.net seems like you can. See Option 2.
But will hang around to see what other experts have to offer.