“断点当前不会被击中”尝试调试由.NET代码调用的TSQL存储过程时出错

本文介绍了“断点当前不会被击中”尝试调试由.NET代码调用的TSQL存储过程时出错的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我收到错误：

断点当前不会是命中无法绑定SQL断点此时，包含断点未加载的对象

当我做了步骤调试从应用程序调用的存储过程？

我应该检查什么？

/ p>（VS 2005和SQL Server 2005都运行在同一台PC上，如果我从服务器资源管理器进入，我可以调试一个存储过程）

解决方案

确保在项目属性> Debug>启用SQL Server调试中检查，否则您将无法从代码进入存储过程（即使您可以使用服务器资源管理器）。必须是执行项目。

如果您从SqlCommand调用存储过程，请在Command.Execute（）行上设置断点，然后再进入。从那里你将被带到存储过程代码，并可以通过它。

如果继续获取空断点图标，请尝试刷新服务器资源管理器。

I am getting the error:

"The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded"

When I did the steps to debug a stored proc called from my app?

What should I be checking?

(VS 2005 and SQL Server 2005 both running on the same PC, I can debug a stored proc if I do "step into" from the Server Explorer)

解决方案

Make sure that in the project properties > Debug > 'Enable SQL server debugging' checked otherwise you won't be able to step into a stored procedure from your code (even though you can step through it using server explorer). Has to be the executing project.

If you're calling the stored procedure from a SqlCommand, set a break point on the Command.Execute() line and then step into it. From there you will be taken to the stored procedure code and will be able to walk through it.

If you continue to get the empty breakpoint icon, try refreshing server explorer.