SQL Debugging: Object containing the breakpoint not loaded

[Sam]

I am trying to setup debugging so I can break inside a stored procedure that
is called from my application.
I am able to debug stored procedures by right clicking and selecting step
into.

But when I set a break point and run my application, the breakpoint appears
with a question mark with the message:
Break point will not currently be hit. Unable to bind SQL breakpoint at this
time. Object containing the breakpoint not loaded.

How do I load the object containing the breakpoint?

I am running XP Pro, IIS5, SQL2000 all on the same computer.

I have followed everthing in the MSDN, which includes:
Start SQL Server, IIS with admin.
Run Remote Components Setup.
Security access to sp_sdidebug.
Security access to DCOM.
Add users to Debugger Users
Copied MSSDI98.DLL to the SQL Binn directory
Ensured SQLLE.DLL, SQLDBG.DLL, MSSDI98.DLL, SQLDBREG2.EXE exist.

Thanks in advanced for any help.
Sam

[Min kwan Park[MSFT]]

Hi There,

thanks for your posting.
related with your issue, I got some questions.
- Is your app project enabled for SQL debugging?
- did you make connection to SQL server with "Server explorer" before you
start debugging with your App?

your answer will help me to understand situation better and let me help you
further.

Thanks,

--
Min Kwan Park, C# community room Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[Sam]

Hi,
In the project properties I have debugging enabled for
ASP.NET and SQL Debugging only.
In the server explorer I expand through the server to my
stored procedure, double click it and set a breakpoint,
then run my application.

thanks
Sam

>.
>