7

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up:

Microsoft SQL Server Management Studio:
Unable to Step. Invalid Operation.

Once I dismiss the dialog, it appears that debugging CAN continue... I can continue to step through the code to the end, without any apparent problems. So far....

  • Did you ever find a solution to this? – IanW Mar 28 '13 at 18:23
  • @IanW I'm afraid I didn't find a solution at the time, and I've actually moved on from that role now. – CJM Mar 28 '13 at 18:57
3

I had the same problem. After some research I found this page which suggests that this is caused by a race condition. Although the workaround given there wasn't applicable for me, after stopping every other debugging processes (Visual Studio) these annoying error messages didn't display anymore.

| improve this answer | |
  • Thanks! I finally know why I get this error on every version of SQL Server - it's because I usually have Visual Studio running, and I'm debugging something in VS, and then I go to debug one of the stored procedures. Thanks!!!!! – Colin Jan 9 '18 at 1:46
  • Please upvote this issue if you experience it too: connect.microsoft.com/SQLServer/feedback/details/3068631/… – Colin Jan 9 '18 at 1:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.