无法在SQL中执行无效操作 [英] Unable to step invalid operation in SQL

问题描述

我正在调试SSMS中的存储过程调用（2012）。经常和代码中的各种随机点会弹出一个对话框：



一旦我关闭对话框，看来调试CAN继续......我可以继续逐步完成代码，没有任何明显的问题。到目前为止....



我尝试了什么：



Microsoft SQL Server Management Studio：

无法执行步骤。操作无效。

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

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....

What I have tried:

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

推荐答案

无法访问您的服务器以查找自己，您最好的选择是使用谷歌。



快速查看下面的一些链接，看起来在调试过程中是一个竞争条件太快，似乎是SSMS 2012中一个众所周知的问题。也包括在下面的链接中。



Microsoft SQL Server Management Studio：无法执行步骤。无效操作 - Google搜索 [ ^ ]



无法执行步骤。操作无效。 SSMS 2012 | Microsoft Connect [ ^ ]



ssms - SQL Server调试：无法执行。无效操作 - 服务器故障 [ ^ ]



获取无法执行。操作无法完成。应在Visual Studio中进行调试时执行重试 - Rakki Muthukumar [ ^ ]

Without having access to your server to look for myself, your best bet is going to be to use google.

A quick look through some of the links below looks like it is a race condition in debugging too quickly and appears to be a well known issue in SSMS 2012. Work arounds are included in the links below as well.

Microsoft SQL Server Management Studio: Unable to Step. Invalid Operation - Google Search[^]

Unable to step. Invalid operation. SSMS 2012 | Microsoft Connect[^]

ssms - SQL Server Debugging: "Unable to Step. Invalid operation" - Server Fault[^]

Getting "Unable to step. The operation could not be completed. A retry should be performed" while debugging in Visual Studio – Rakki Muthukumar[^]

这篇关于无法在SQL中执行无效操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！