How to enable debugging of stored procedures in visual studio?

Question

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.

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

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

My currents setup:

1. visual studio 2008 SP1
2. SQL server 2005 express database (yes you can debug on this)
3. DEV database on my localmachine with "root" login as 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

Answer 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...)

[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.

Answer 2

I've got the Pro version. I know it should be there but isn't.

Answer 3

help? I'm still here, need answer...

Answer 4

Just Select you connection in Server explore and right click on that, and select 'Allow SQL/CLR Debug'

Thanks Sethupathi

Answer 5

I have the pro edition and the option is there but basically it doesn't jump into the store procedure...