Debug Stored Procedure

Hi!
How can I do to debug a Stored Procedured?
Thsnks.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
"Jaime Lucci" <jaimelucci@.hotmail.com> wrote in message
news:ealWLHS8FHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> How can I do to debug a Stored Procedured?
> Thsnks.
>|||Do I need VS .Net 2003 or do I have to use VS .Net 2005 to debug a SQL 2005
SP?
On Thu, 24 Nov 2005 19:58:21 -0000, "Tony Rogerson" <tonyrogerson@.sqlserverf
aq.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.