SQL Debugging in VS2005 Problems

Hi,

I'm trying to debug an SQL 2005 store procedure within Visual Studio
2005. I open the store procedure via the server explorer and place the
break points where I want them. I then select 'Step Into Store
Procedure' it loads the debugger and asks for the parameters. However
all the breakpoints are then greyed out and when hovered over it says:

'The breakpoint will not currently be hit. Unable to bind SQL
breakpoint at this time. Object containing the breakpoint not loaded.'

Then when I try to step through the store procedure the debugger exits.
Is there anything else that needs to be done to debug a store
procedure?

I've already looked at this article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;817253
but the names have not changed and the problem still occurs.

Any help would be much appreciated.

Thanks

Simon

.

Relevant Pages

  • Re: Amazming....but curious...
    ... I know that using sp or sql text does not matter with strongly typed dataset. ... I guess store procedure is different story. ... typed dataset was be able to query insert or update without the sp in my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: CASE (or similar) in SQL
    ... then you can use the logic inside the store procedure to generated it in your application and send it as a batch. ... "Caminar sobre el agua y desarrollar software a partir de unas ... Is there any way to do something like this in SQL? ... What I want to do is to basically do the statement as one batch rather than having to check something, come back to the app, then reconstruct the sql and sending it back. ...
    (microsoft.public.sqlserver.programming)
  • Re: DateTime not nullable problem
    ... data type that is nullable, designed specifically for SQL use. ... > calling store procedure in the db, ... >> Kevin Spencer ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Amazming....but curious...
    ... Stored Procedures can run faster than a lot of generated code. ... you will find that SQL "on the fly" can actually be faster if you hit a condition that forces procedure recompile or replan. ... I guess store procedure is different story. ... typed dataset was be able to query insert or update without the sp in my ...
    (microsoft.public.dotnet.framework.adonet)
  • Remote-Debugging auf SQL2000 mit VS2005
    ... der SQL Server ist aber eine Remote-Server ... Wenn ich VS2005 im Debug starte, heisst es bei den Breakpoints im T-SQL. ... "The Breakpoint will not currently be hit. ...
    (microsoft.public.de.sqlserver)