This is a discussion on Can not debug SQL sever 2005 Stored procedure from Visual Studio 2005 - DOTNET ; I am trying to debug a SQL server 2005 SP in VS 2005. I understand that there are two types of debugging (actully 3 but I am ignoring SQL/ CLR SPs written in C# etc). 1. Direct database debugging where ...
I am trying to debug a SQL server 2005 SP in VS 2005. I understand
that there are two types of debugging (actully 3 but I am ignoring SQL/
CLR SPs written in C# etc).
1. Direct database debugging where in we select SP and use 'Step Into
Stored procedure' otion to debug. I tried that and it seems to start
debugging session ( I can debug output 'Running [dbo].
[spTestSqlDebugging]...' in output window) but nothing seems to
happen. It prompts me for parameters etc but then no window with SP
code and cursor pointing to line of execution appears there (seems
like the winodw is hidden somewhere). I tried each and every option in
menu related to viewing all kinds windows but still dont get that.
Then i have checked my widnwos firewall and its disabled. i am logged
in as domain admin and SQLDebuggerUser is memeber of admini group. So
even with all these settings I am unable to step into SP.
2. the other SP debugging where in I want to break into SP from
managed code is also not working. I have setup breakpoint but opening
SP in edit mode. I have enabled 'SQL debugging' from .NET
projectproperties in VS2005. I have even enabled SQL/CLR debugging on
the data connection I am using from my ADO.NET (thought I dont think
it is required in this case as I belive it is required only if I want
to debug a managed SP deployed in SQL server). All the secuirty
related checks I mentioned above are still applicable (i.e. there are
no security restrictions that I can think of) but still i can not
Thanks in advance