VS 2005 Standard Edition

15 Jul 2006 4:39 AM

Joe Delphi

Hi,

      I want to debug a stored procedure. I am using Visual Studio 2005
Standard Edition and SQL Server 2005 Express.   I open the stored procedure
but it will not let me set a breakpoint. I can see menu items with terms
like Toggle Breakpoint, but they are grayed out.

      Does this mean that the Standard Edition of VS 2005 does not allow
stored procedure debugging?

JD

15 Jul 2006 8:24 AM

Helmut Woess

Am Fri, 14 Jul 2006 21:39:23 -0700 schrieb Joe Delphi:

> Hi,
>
>       I want to debug a stored procedure. I am using Visual Studio 2005
> Standard Edition and SQL Server 2005 Express.   I open the stored procedure
> but it will not let me set a breakpoint. I can see menu items with terms
> like Toggle Breakpoint, but they are grayed out.
>
>       Does this mean that the Standard Edition of VS 2005 does not allow
> stored procedure debugging?
>
> JD

http://msdn.microsoft.com/vstudio/products/compare/

If i interpret the information right, then you can debug SQL Server (only)
if the server is local. For remote server you need professional edition.

bye, Helmut