How to use a debugger on stored procedures

Please kindly advise in details how to use a debugger on stored procedures.
Thanks.Follow the steps here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfsettingupsqldebuggingenablingsqldebugging.asp
The full menu of articles is here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfsettingupsqldebugging.asp
|||The links provided are related to debugging in VS only. Is there any link related to debugging in a SQL Server instance?
Thanks much.|||you can use a SQL Profiler.|||

thuhue wrote:

The links provided are related to debugging in VS only. Is there any link related to debugging in a SQL Server instance?
Thanks much.

Caddre provided a link in a previous post:http://forums.asp.net/929991/showpost.aspx