“断点当前不会被击中”尝试调试由.NET代码调用的TSQL存储过程时出错 [英] "The breakpoint will not currently be hit..." error when trying to debug a TSQL stored proc called by .NET code

问题描述

我收到错误：

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

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

我应该检查什么？

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

解决方案

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

如果您从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 .net 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 .net 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.

这篇关于“断点当前不会被击中”尝试调试由.NET代码调用的TSQL存储过程时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！