如何在visual studio中启用存储过程的调试？

Ok, this is driving me nuts.

好吧，这让我疯了。

I've done just about everything I can to enable step through debugging of stored procedures of a sql server 2005 database.

我已经完成了我能做的一切，以便逐步调试sql server 2005数据库的存储过程。

http://arjunachith.blogspot.com/2007/05/debugging-stored-procedures-debug.html

http://arjunachith.blogspot.com/2007/05/debugging-stored-procedures-debug.html

http://msdn.microsoft.com/en-us/library/zefbf0t6(vs.71).aspx

http://msdn.microsoft.com/en-us/library/zefbf0t6(vs.71).aspx

My currents setup:

我的电流设置：

1. visual studio 2008 SP1
2. visual studio 2008 SP1
3. SQL server 2005 express database (yes you can debug on this)
4. SQL server 2005 express数据库（是的，你可以调试这个）
5. DEV database on my localmachine with "root" login as sysadmin
6. 我的localmachine上的DEV数据库，“root”登录为sysadmin

All I want to do is right click on a stored proc in my server explorer in VS 2008 and see "step into stored procedure". I've done all I can and I can't see that. I'm just trying to access a local database on my local machine, I've created an account

我想要做的就是在VS 2008中的服务器资源管理器中右键单击存储过程，然后查看“步入存储过程”。我已尽我所能，我无法看到。我只是想在本地机器*问本地数据库，我创建了一个帐户

3 个解决方案

#1

What edition of VS2008 are you running? I just checked on Pro and Team System, and I get that option on both; I also have C# Express, and it doesn't give this option. (I don't have Standard, so can't check that one...)

你在运行什么版本的VS2008？我刚刚检查了Pro和Team System，我得到了两个选项;我也有C＃Express，它没有提供此选项。 （我没有标准，所以不能检查那个...）

[edit] From the second link you provided (MSDN), on the right-hand side there's a link for VS2008 that indicates it only applies to Pro and Team.

[编辑]从您提供的第二个链接（MSDN），在右侧有一个VS2008的链接，表明它仅适用于Pro和Team。

#2

Just select your connection in Server Explorer and right click on that, and select Allow SQL/CLR Debugging

只需在Server Explorer中选择您的连接并右键单击它，然后选择Allow SQL / CLR Debugging

#3

To do sql debugging in managed code or visual studio, visual studio should be configured to enable sql server deubugging. this link helps you with direct solution http://support.microsoft.com/kb/316549 and http://msdn.microsoft.com/en-us/library/aa984533(v=vs.71).aspx but the edition of the visual studio should be considered.Pls refer this http://msdn.microsoft.com/en-us/library/ms165038(v=vs.80).aspx.

要在托管代码或visual studio中进行sql调试，应将visual studio配置为启用sql server deubugging。此链接可以帮助您直接解决http://support.microsoft.com/kb/316549和http://msdn.microsoft.com/en-us/library/aa984533(v=vs.71).aspx但版本应该考虑视觉工作室。请参阅http://msdn.microsoft.com/en-us/library/ms165038(v=vs.80).aspx。

Apparently, You might not get Debug tab though the versions are pro/team and if its a web application project. To make it work, you need to select web tab-->scroll the screen very down-->Get 3 options as in below image.

显然，你可能没有得到Debug选项卡，虽然版本是pro / team，如果它是一个web应用程序项目。要使其工作，您需要选择Web选项卡 - >向下滚动屏幕 - >获取3个选项，如下图所示。