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.

Who is Participating?
Mark WillsConnect With a Mentor Topic AdvisorCommented:
Oh, and in VS2010 you used to connect to Server Explorer but in more recent, you now connect to SQL Server using Sql Server Object Explorer.

There is a good example here : 

Seems like I need to brush up a bit more :) Still has a few limitations though...
Mark WillsTopic AdvisorCommented:
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 seems like you can. See Option 2.

But will hang around to see what other experts have to offer.
toshi_Author Commented:
Thank you Mark !

Mark WillsTopic AdvisorCommented:
A pleasure, and thank you very much for your question :)

Mark Wills
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.