Unable to Debug Stored Procedure with Visual Studio 2005 and Microsoft SQL Server 2005 (Visual Studio 2005 SQL server 2005 Unable to debug Stored Procedure)

I am unable to debug on a stored procedure when running my website in Debug Mode.  

In VS 2005, I have a Solution: GLAdjustments containing the following:
          a SQL database Project: GLAdjustments_SQL   {GLSQL}
          a WebSite Project (c:\inetpub\wwwroot\apps\GLAdjustments) {GLWeb}
          and a Business Layer Project (Windows Class? Library Project) GLAdjustments_Business {GLBiz}


GLSQL only contains scripts used to create tables, procedures, modifications, etc.    GLWeb contains only presentation layer items and objects.  GLBiz contains all business and data layer connections.   I've set debugging on GLBiz to Enable SQL Debugging.

From within GLWeb, i click F5 and start debugging.  I F10/f11 and what not to get to my code (as follows) and break on the first line.  I then step through my procedure in an attempt to enter the stored proc.  Is this possible?  I can right click on the stored procedure from server explorer and "Step into" the script to execute it.  I need, however, to be able to view it while i'm running the website and see what is going on.

Can you recommend a 3rd party solution if this is not possible with visual studio.

thanks.




=========================================================================================================
        Dim sqlConn As New SqlConnection(dbConn_GLAdjustment)  'Conn String established elsewhere, new conn for ease of testing/debugging.
        Dim sqlCmd As New SqlCommand  

        With sqlCmd 'set command options
            .CommandType = Data.CommandType.StoredProcedure
            .CommandText = "GLAdjustments_GetAdjustments"

            .Parameters.Add(New SqlParameter("@Business_Unit", Business_Unit_Selected))

            .Connection = sqlConn
        End With

        Dim da As New SqlDataAdapter()
        da.SelectCommand = sqlCmd
        Dim DS As New xsdAdjustments
        da.TableMappings.Add("Table", DS.Adjustments.TableName.ToString())

        da.Fill(DS)

        Return DS
Start Free Trial