在Managementstudio中调试存储过程-DebuggingstoredproceduresinManagementstudio

24  

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.

只有SQL 2008和SSMS 2008。选择菜单“调试\开始调试”或按Alt+F5，将逐步启动T-SQL调试器。

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.

在2005年，惟一的方法是为SP:StmtCompleted事件附加分析器和监视器，这不是逐步调试器，但至少您将看到执行流。很明显，在生产机器上是做不到的。

21  

I have written a pretty detailed blog post about it here:

我在这里写了一篇非常详细的博文:

http://www.diaryofaninja.com/blog/2010/11/23/debugging-sql-queries-function-amp-stored-procedures-with-sql-management-studio

http://www.diaryofaninja.com/blog/2010/11/23/debugging-sql-queries-function-amp-stored-procedures-with-sql-management-studio

Basically the gist of it is that you enter your sql query to execute your stored procedure, and instead of pressing F5 or hitting the exclamation, you hit the play button and use F10 and F11 to step through and step into your stored procs.

主要的要点是，输入sql查询来执行存储过程，而不是按下F5或按下调用，而是按play按钮，然后使用F10和F11来逐步进入存储的proc。

This is very handy but no one seems to use it.

这很方便，但似乎没有人使用它。

4  

The ability to debug sprocs, which was in Query Analyzer in SQL Server 2000 was not put into SQL Server 2005. Microsoft realized this mistake and put the functionality back in in SQL Server 2008.

在SQL Server 2000中的查询分析器中调试sprocs的能力没有被放到SQL Server 2005中。微软意识到这个错误并将其功能恢复到SQL Server 2008中。

In SSMS 2008 you can start the debugger by either clicking the debug button on the toolbar or pressing ALT+F5.

在SSMS 2008中，您可以通过单击工具栏上的debug按钮或按ALT+F5启动调试器。

Unfortunately, running SSMS 2008 against a 2005 database will not allow you to debug, so you'll have to stick with Visual Studio.

不幸的是，针对2005数据库运行SSMS 2008将不允许您进行调试，因此您必须坚持使用Visual Studio。

3  

Watch out for debugging stored procedures using Visual Studio. The way that this is implemented is to use an incredible amount of locking so that you should never do this on a production system.

注意使用Visual Studio调试存储过程。实现这一点的方法是使用大量的锁定，因此您永远不应该在生产系统上这样做。

2  

Yes, in SSMS 2008 you can definitely step into T-SQL code (code block, stored func, stored proc) and debug it.

是的，在SSMS 2008中，您可以进入T-SQL代码(代码块、存储的func、存储的proc)并对其进行调试。

See this excellent article Management Studio Improvements in SQL Server 2008 for details - it also deals with debugging (towards the end of the article).

有关详细信息，请参阅SQL Server 2008中这个优秀的文章管理Studio改进—它还处理调试(在本文末尾)。

1  

Please be aware when debugging remote instances with SSMS that your server and client firewall will need to allow sqlservr.exe and ssms.exe respectively, along with tcp port 135. The client firewall in my particular case was causing a "timeout expired" when attempting to debug.

请注意，当使用SSMS调试远程实例时，您的服务器和客户端防火墙需要允许sqlservr。exe和地对地导弹。exe，连同tcp端口135。在我的示例中，客户机防火墙在尝试调试时导致“超时过期”。