The Repair did not help. The weird thing is that I can debug SPs by right-clicking the SPs and selecting "Step into Stored Proc" but not when the SP is called from the code!


>Eric,
>
>Did you by chance install SQL Server after VS.NET? If so then I would suggest running a VS.NET repair. I've seen where VS.NET needs to make some updates to your files when SQL Server is already installed.
>
>>I follow the steps from
>>http://support.microsoft.com/default.aspx?scid=kb;[LN];316549 to debug
>>stored procedures from VS.Net 2002 Enterprise Architect (with a local SQL
>>Server 2000 SP3 ON XP Pro SP1) .
>>
>>I follow the steps of Option 1 and it executes exactly like it is written.
>>
>>I follow the steps of Option 2 and ... it doesn't work!
>>
>>When I start the application, I can see a white question mark on the
>>breakpoint of the Stored Proc. The tooltip say:
>>"The breakpoint will not currently be hit. Unable to bind SQL breakpoint at
>>this time. Object containing the breakpoint is not loaded."
>>
>>Any ideas?