To debug store procedure of sql server 2000 in .net

See more:

SQL-server-2000

SQL-Server

Some step done for debugging store procedure as belows:
1>I connect my database through server explorer.
2>Right click that procedure which i will debugging
3>click open option the procedure.
4>Set the break point location.
5>again Right click that procedure.
6>click step into procedure option.
7>supply the parameter value.
But yet not hold the break point at debugging mode.
I get this message:'The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded.'

How will i debug store procedure of sql server 2000 in .net framework??
Please help me anybody in right way....