locked
Debugging Stored Procedure from Visual Studio 2005 RRS feed

  • Question

  • Hi ,

    I am using Visual studio 2005 with sql server 2005. I want to debug my stored procedure, which is situated on the server on the network(accessible through network share). I followed the following URL:


    http://aspnet.4guysfromrolla.com/articles/051607-1.aspx


    I have used Direct database debugging : When I right click my stored procedure and click 'step into stored procedure', I get the following error:


    "Unable to start T-SQL debugging. could not attach to SQL server process on 'sql_server_name'. The remote procedure call failed and did not execute"


    I am a sysadmin in SQL server. I am using windows authentication to  login to sql server


    Any help?

    Monday, March 3, 2008 8:17 PM