SQL Server 2005 Debugging

Dr_Evil · 1 Nov 2006 at 11:23

Can anyone tell me how to debug a stored procedure in SQL Server 2005? Is this done through the Management Studio, or Visual Studio 2005? I have VS2005 Standard Edition, is this even possible to do it through there?

Can't find any debug options in either. Please help!

Dr_Evil · 1 Nov 2006 at 11:55

could you tell me how I do this exactly? I don't see any debugging options and i have tried following steps from several sites.. Am I missing something?

How do i attach to the SQL Server 2005 process then? Can this be done in VS2005 Standard at all?

Dr_Evil · 1 Nov 2006 at 16:51

OK so you can only create database projects and debug stored procedures in VS2005 Pro, not in Std.

I have tried finding out how to debug SP's in the SQL 2005 Mgmt. Console but I think this functionality has been moved to VS 2005 now, unless someone can tell me how to do this?

Looks like i'm stuck with a non-debuggable environment here... ;-(

Dr_Evil · 1 Nov 2006 at 17:22

T-SQL. I just tried attaching to the "sqlserv.exe" process but nothing, can't set any breakpoints either.

Strange you have to have Visual Studio to be able to debug SQL Server code.

I rather not do it the old-fashioned way (outputting variable values etc..) so I'm looking for some advice from someone who's been able to do this.. if there is..