调试不显示当前的存储过程版本 [英] Debugging does not show current stored procedure version
问题描述
为了强制我可以做什么SSMS呈现当前版本的代码?
提前感谢
SQL Server中存在多年的这个问题。通常情况下需要几个时间启动和停止调试器,然后才能与源的正确版本同步。
您还将注意到,几个窗口打开,显示调试器知道的最后一个来源。他们需要关闭。即使它是一个皮塔饼,解决问题的最快方法是停止管理工作室并重新启动。
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.
What can I do in order to force SSMS into presenting the current version of the code?
Thanks in advance.
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.
这篇关于调试不显示当前的存储过程版本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!