How do I debug a stored procedure within Visual Studio?
The following MSDN help topic provides instructions for debugging stored procedures from within Visual Studio:
Comment or report problem with topic