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?