Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Debugging Stored Procedure from Visual Studio 2005

Author  Topic 

payal27778
Starting Member

1 Post

Posted - 2008-03-03 : 15:34:30

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?
   

- Advertisement -