为什么我的断点没有从网络服务器的Visual Studio 2019调试脚本中击中SQL

问题描述

因此，我很遗憾无法在使用SSMS18的组织中工作，这意味着我没有用于SSMS的内置调试器.我被降级为使用VS2019 Professional设置断点并逐步执行存储过程.不，Biggie，对吗?

好吧，当我选择"Execute with Debugger"(由于某种原因在GIF中看不到选择)时，它就会加载并执行，并且永远不会碰到我的断点.

我没有关注下面的这些帖子.

任何帮助都将不胜感激.

解决方案

下载并安装SSMS版本<版本18.这样您就可以进行调试了.

So I am unfortunate enough to work in an organization who uses SSMS18, meaning I don't have the built-in debugger for SSMS. I am relegated to using VS2019 Professional to set break points and step through stored procedures. No Biggie, right?

Well when I select "Execute with Debugger" (can't see the selection in GIF for some reason) it loads then executes and never hits my breakpoint.

I followed these posts below to no avail.
How to debug stored procedure in VS 2015?This one I could not find what he was describing in step 6, but I debugged a SQL-Query in VS2019 before, but that was a local instance and not a remote server like it is in this case.

Cannot execute breakpoint inside stored procedure from VS 2017

below is a gif of what is happening

Any and all help is greatly appreciated.

解决方案

Download and Install a version of SSMS < version 18. Then you will be able to debug.

这篇关于为什么我的断点没有从网络服务器的Visual Studio 2019调试脚本中击中SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！