调试不显示当前存储过程版本
我正在开发一个 SQL Server 2008 R2 实例.我刚刚更改了存储过程的代码.当我尝试调试该 proc 时，SSMS 调试窗口显示代码的 older 版本.
I'm working on a SQL Server 2008 R2 instance. I've just changed the code for a stored procedure. When I try to debug that proc, the SSMS debug window shows the older version of the code.
如何强制 SSMS 显示当前版本的代码?
What can I do in order to force SSMS into presenting the current version of the code?
提前致谢.
推荐答案
这个问题在 SQL Server 中已经存在多年了.在与正确版本的源代码同步之前，启动和停止调试器通常需要一些时间.
This problem has existed for years in SQL Server. It usually takes a couple time starting and stopping the debugger before it syncs up with the correct version of the source.
您还会注意到打开了几个窗口，显示调试器知道的最后一个源.他们需要关闭.即使是皮塔，解决问题的最快方法是停止管理工作室并重新启动它.
You will also notice that a few windows are open showing the last source the debugger is aware of. They need to be closed. Even though it is a pita, the fastest way to clear the problem is to stop management studio and restart it.
相关文章