SQL Server -- Is it possible to step through a stored procedure

Question

I have a stored procedure being executed from an ASP.NET application. Is it possible to attach to the procedure and step through it using SQL Server 2005?

Note, in this instance, I am not using a DataAdapter. I'm going in blind. The connection string is being created on the fly, so I don't have access to the schema from the Visual Studio 2005 designer.

I was hoping for a solution similar, for example, to how you attach to a process on a remote server and when a break point is hit, the debugger fires.

Answer 1

absolutely

http://www.dotnetfunda.com/articles/article27.aspx is a link.

edit sorry realised the initial link was subscription only, this link is better

Answer 2

You can also use SQL Profiler to find out what is going on "behind the scenes".

Answer 3

Have a look at

• Debugging SQL Server 2005 Stored Procedures
• How to debug stored procedure in SQL server 2005
• Debugging a SQL Stored Procedure
• Debugging Stored Procedures in SQL Server 2005
• Debugging Stored Procedures in Visual Studio 2005
• SQL Server 2005 Management Studio Part 2
• Debugging stored procedures on SQL Server 2005

Answer 4

I don't think you can debug a stored procedure directly from your ASP.NET application (i.e. set a break point in your .NET code and the step into a stored procedure), but it is possible to debug it directly using visual studio.

Here is a great article on SQLTeam.com describing how to do that.