问题描述
我一直在尝试调试SQL Server 2005存储过程，在Visual Studio Team System 2008中。我连接到数据库服务器，并右键单击执行，存储过程。我甚至尝试步入存储过程，没有运气。
IDE显示它正在运行，但我似乎不能破解或进入存储过程。
我已经检查过事件查看器，没有日志。没有显示问题所在的输出或消息。
Visual studio包含以下组件： -
载入论坛提到调试问题，但没有找到简单的解决方案。
我错过了什么？或者有谁知道一个更简洁的网站，通过成功的存储过程调试步骤？
检查这个，特别是远程调试部分内容：
有关调试sql的其他一般信息，请检查
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存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！