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
My short answer is "Not Easily". Too many limitations, so never really explored.
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.
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.