Debug Stored Procedure

24 Nov 2005 6:03 PM

Jaime Lucci

Hi!

How can I do to debug a Stored Procedured?

Thsnks.

24 Nov 2005 7:58 PM

Tony Rogerson

If you are using SQL 2000, you can right click on the stored procedure in
Query Analyser and select Debug.

In SQL 2005 you need to use Visual Studio.NET, functionality has been taken
out of Management Studio.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

Show quote

"Jaime Lucci" <jaimelu***@hotmail.com> wrote in message
news:ealWLHS8FHA.1032@TK2MSFTNGP11.phx.gbl...
> Hi!
>
> How can I do to debug a Stored Procedured?
>
> Thsnks.
>
>

25 Nov 2005 3:35 PM

Gaetan

Do I need VS .Net 2003 or do I have to use VS .Net 2005 to debug a SQL 2005 SP?

Show quote

On Thu, 24 Nov 2005 19:58:21 -0000, "Tony Rogerson" <tonyroger***@sqlserverfaq.com> wrote:

>If you are using SQL 2000, you can right click on the stored procedure in
>Query Analyser and select Debug.
>
>In SQL 2005 you need to use Visual Studio.NET, functionality has been taken
>out of Management Studio.