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

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.