在.net中调试SQL Server 2000的存储过程 [英] To debug store procedure of sql server 2000 in .net

问题描述

完成一些调试存储过程的步骤，如下所示:
1>我通过服务器资源管理器连接数据库.
2>右键单击要调试的程序
3>单击打开选项的过程.
4>设置断点位置.
5>再次右键单击该过程.
6>单击进入程序"选项.
7>提供参数值.
但尚未将断点保持在调试模式下.
我收到此消息:``断点当前不会被命中.目前无法绑定SQL断点.包含断点的对象未加载.''

如何在.net框架中调试sql server 2000的存储过程?
请以正确的方式帮助我....

Some step done for debugging store procedure as belows:
1>I connect my database through server explorer.
2>Right click that procedure which i will debugging
3>click open option the procedure.
4>Set the break point location.
5>again Right click that procedure.
6>click step into procedure option.
7>supply the parameter value.
But yet not hold the break point at debugging mode.
I get this message:''The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded.''

How will i debug store procedure of sql server 2000 in .net framework??
Please help me anybody in right way....

推荐答案

尝试
通过SQL查询分析器进行SQL存储过程调试 [ ^ ]
http://www.codeguru.com/csharp/.net/net_debugging/article.php /c19537/ [ ^ ]

Try
SQL Stored Procedure Debugging from SQL Query Analyzer[^]
http://www.codeguru.com/csharp/.net/net_debugging/article.php/c19537/[^]

这篇关于在.net中调试SQL Server 2000的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！