且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在 SQL Server Management Studio 中调试存储过程

更新时间:2022-03-07 23:07:19

仅适用于 SQL 2008 和 SSMS 2008.从菜单调试\开始调试"中选择或按 Alt+F5 将启动分步 T-SQL 调试器.

Only with SQL 2008 and SSMS 2008. Select from menu 'Debug\Start Debugging' or press Alt+F5 and will launch the step by step T-SQL debugger.

在 2005 年,唯一的方法是附加 Profiler 并监视 SP:StmtCompleted 事件,这并不是一步一步的调试器,但至少你会看到执行流程.显然,不能在生产机器上完成.

On 2005 the only way is to attach Profiler and monitor for the SP:StmtCompleted event, which is not exactly debugger step-by-step, but at least you'll see the execution flow. Not to be done on a production machine, obviously.