how to debug the stored procedure in sql server

microsoft.public.sqlserver.programming

17 Mar 2006 12:08 PM

shiva

hi! all,

i have a problem , i want to debug the stored procedure in sql server.

help me

thanks in advance

shiva

17 Mar 2006 1:16 PM

Amarnath

Hi,
Are you using SQL SERVER 2K5 or 2K?

In 2000 click on the object browser from view. select the database and
stored procedure and right click and go to the bottom for debug.

In 2005 You need to go from visual Studio ->view->server explorer and click
the stored proc for debugging.

Debugging from VS 2003 or 2005 is convenient.

Amarnath

Show quote

"shiva" wrote:

> hi! all,
>
>
> i have a problem , i want to debug the stored procedure in sql server.
>
> help me
>
> thanks in advance
>
> shiva
>
>