调试SQL Server 2000 [英] To debug sql server 2000

问题描述

我安装的sql server 2000配置为混合模式身份验证&空密码&本地用户帐户.
我创建了一个存储过程.但是，当我调试该过程时，我转到某个步骤，即-右键单击该过程+单击调试选项.显示一个窗口，即-如果在将SQL Server配置为作为服务运行时以``本地系统帐户''身份登录，``SP调试可能无法正常进行.
您是否要继续?".有三个按钮-是，否，取消.我单击是按钮.
我提供一些参数值，然后单击执行"按钮.
将显示一个调试窗口，转到"，切换断点和删除所有断点"按钮处于启用状态，但进入，越过，跳出和遇到光标均处于禁用状态.

我将如何解决调试该程序的问题?
请帮助我任何指示...

My installed sql server 2000 is configured as mixed mode authentication & blank password & local user account.
I create a store procedure.But when i debug this procedure, i go to some step i.e.- right click on that procedure+click debug option. A windows is shown i.e.-''SP debugging may not work properly if you log on as ''Local System Account'' while SQL Server is configured to run as a service.You can open to see details.
Do you wish to continue?''.There have three button-Yes,No Cancel. I click yes button.
I give some parameter value and then click execute button.
A debugging windows is shown, Go,Toggle Breakpoints & Remove all Breakpoints button are enable but step into, step over, step out & run into cursor are disable.

how will i solve to debug that procedure???
Please help me any instruction...

推荐答案

这些链接将对您有所帮助:-

http://www.codeguru.com/csharp/.net/net_debugging/article.php /c19537/ [ ^ ]

these links will be helpful:-

http://www.codeguru.com/csharp/.net/net_debugging/article.php/c19537/[^]

3,620,000 results on debugging in sql server 2000

Please don''t forget to mark this as your answer if it helps you out.

Thanks

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