Debugging in SS2005 ?

14 Jul 2006 2:36 PM

Joe Delphi

Hi,

     In SQL Server 2000, I am used to using the stored procedure debugging
feature in the Query Analyzer to debug my stored procs.

     We recently switched over to SS2005 and I am using SQL Server
Management Studio - but cannot figure out how to debug.   There don't appear
to be any menu items or controls that will allow me to debug my stored
procs.

     Can anyone tell me how to debug a stored proc in SS2005 ?

JD

14 Jul 2006 2:57 PM

Dan

SSMS does not support stepping into stored proc as query analyzer did.
You have to use Visual Studio 2005 (the Server Explorer) to step into
stored proc's in SQL Server 2005.

Dan

"Joe Delphi" <delphi561@nospam.cox.net> wrote in message

news:7_Ntg.12063$6w.11488@fed1read11:

Show quote

> Hi,
>
>      In SQL Server 2000, I am used to using the stored procedure debugging
> feature in the Query Analyzer to debug my stored procs.
>
>      We recently switched over to SS2005 and I am using SQL Server
> Management Studio - but cannot figure out how to debug.   There don't appear
> to be any menu items or controls that will allow me to debug my stored
> procs.
>
>      Can anyone tell me how to debug a stored proc in SS2005 ?
>
> JD