Unable to debug stored procedures in Visual Studio .NET



I have a problem in debugging stored procedures in Visual Studio.NET 2003

Visual Studio.NET 2003 & SQL Server 2000 are both installed on the same
computer of Windows XP Professional.

Now, I try to debug the stored procedure in standalone mode, and following
are my operations:
1) startup Visual Studio 2003, no solution is opened.
2) open 'Server Explorer'
3) expand server nodes and find the target stored procedure, say, foo
4) right click on the stored procedure, and select 'Step Into Stored
Procedure' menu item
5) the procedure's source codes appear in the working space, and a dialog
box('Run stored procedure) is poped up to allow inputing parameters
6) correctly input the parameters, and click 'OK' button
7) the dialog disappears, and IDE is in debug mode, but no highlight line,
no prompt.

So, I don't know what should I do to setup the debugging environment.

Thanks in advance.


.


Loading