Hi Rex,

The following article explains how to set this up:

Q316549 HOW TO: Debug Stored Procedures in Visual Studio .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316549

>All,
>
>I need to debug a stored procedure as part of my application. I set a break point in the stored procedure and ran the application in Debug mode, but the break point was not triggered even though the code executed.
>
>Is there some setting I need to allow stored procedure inline debugging?
>
>TIA
>
>Rex