Debug SP not stopping on Breakpoint

I was able to pull up a stored procudure in .Net using the Server Explorer.
I
double clicked the SP to pull it up, added a few breakpoints, then I right
clicked on the SP, selected Step Through, then entered the parameter value.
There is no evidence that anything is happening or happened. How do I get th
e
yellow bar to show up so I can see it stepping through the SP?Troubleshooting tips for T-SQL Debugger in Visual Studio .NET
http://support.microsoft.com/newsgroups/default.aspx
AMB
"Mike L" wrote:

> I was able to pull up a stored procudure in .Net using the Server Explorer
. I
> double clicked the SP to pull it up, added a few breakpoints, then I right
> clicked on the SP, selected Step Through, then entered the parameter value
.
> There is no evidence that anything is happening or happened. How do I get
the
> yellow bar to show up so I can see it stepping through the SP?|||Hi,
Additionally to AMB's Knowledge Base article, here is some others for your
reference
INF: Advanced Debugging of SQL Server Procedures
http://support.microsoft.com/?id=163451
Troubleshooting tips for T-SQL Debugger in Visual Studio .NET
http://support.microsoft.com/?id=817178
Debugging Stored Procedures
http://www.windowsitpro.com/Article...6356/16356.html
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.