无法在Visual Studio Team System 2008中调试SQL Server 2005存储过程 [英] Unable to debug SQL Server 2005 stored procedures in Visual Studio Team System 2008

问题描述

我一直在尝试调试SQL Server 2005存储过程，在Visual Studio Team System 2008中。

我连接到数据库服务器，并右键单击执行，存储过程。我甚至尝试步入存储过程，没有运气。

alt text http://ferdspics.googlepages.com/vs-executesproc.JPG

IDE显示它正在运行，但我似乎不能破解或进入存储过程。

alt text http://ferdspics.googlepages.com/vs-executesproc-ideshowsitsrunning.JPG

我已经检查过事件查看器，没有日志。没有显示问题所在的输出或消息。

Visual studio包含以下组件： -

alt text http://ferdspics.googlepages.com/vs.JPG

载入论坛提到调试问题，但没有找到简单的解决方案。

我错过了什么？或者有谁知道一个更简洁的网站，通过成功的存储过程调试步骤？

解决方案

检查这个，特别是远程调试部分内容： http://www.dbazine.com/sql/sql-articles/cook1

有关调试sql的其他一般信息，请检查 http://msdn.microsoft.com/en-us/library/zefbf0t6.aspx

I have been trying to debug SQL Server 2005 stored procedures, in Visual Studio Team System 2008.

I connected to the database server and did a right-click "Execute", on the stored procedure. I even tried "Step Into Stored Procedure", with no luck.

alt text http://ferdspics.googlepages.com/vs-executesproc.JPG

The IDE shows it is running, but I can not seem to break or step into the stored procedure.

alt text http://ferdspics.googlepages.com/vs-executesproc-ideshowsitsrunning.JPG

I have checked the event viewer and there are no logs. There are no output or messages showing where the problem is.

Visual studio contains the following components :-

alt text http://ferdspics.googlepages.com/vs.JPG

Loads of forums mention debugging issues, but no simple solution were found.

Am I missing something ? Or does anyone know of a more concise site, that walks through successfull stored procedure debugging ?

解决方案

Check this, specially the remote debugging part: http://www.dbazine.com/sql/sql-articles/cook1

For other general information on debugging sql check http://msdn.microsoft.com/en-us/library/zefbf0t6.aspx

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