Sql debugger

17 Aug 2006 5:43 AM

New

i had read in msdn about sql debugger for debugging of stored procedures and
queries. but i am not able to find the
sql debugger tools. can anyone give some idea about the same.

Thanks.

Mitesh

17 Aug 2006 12:13 PM

Hari Prasad

SQL Server 2000 has a built-in T-SQL debugger. See the article on the usage
for TSQL debugger,

http://www.15seconds.com/issue/050106.htm

Thanks
Hari
SQL Server MVP

Show quote

"New" <mit***@viraat.com> wrote in message
news:OyV6mAcwGHA.3420@TK2MSFTNGP06.phx.gbl...
>i had read in msdn about sql debugger for debugging of stored procedures
>and
> queries. but i am not able to find the
> sql debugger tools. can anyone give some idea about the same.
>
> Thanks.
>
> Mitesh
>
>

22 Aug 2006 2:40 PM

Mitesh

thanks hari.
i had read article and was able to debug the stored procedure.

Thanks to all.

Mitesh

"Hari Prasad" <hari_prasa***@hotmail.com> wrote in message news:OES3PafwGHA.1808@TK2MSFTNGP06.phx.gbl...

SQL Server 2000 has a built-in T-SQL debugger. See the article on the usage
for TSQL debugger,

http://www.15seconds.com/issue/050106.htm

Thanks
Hari
SQL Server MVP

Show quote

"New" <mit***@viraat.com> wrote in message
news:OyV6mAcwGHA.3420@TK2MSFTNGP06.phx.gbl...
>i had read in msdn about sql debugger for debugging of stored procedures
>and
> queries. but i am not able to find the
> sql debugger tools. can anyone give some idea about the same.
>
> Thanks.
>
> Mitesh
>
>

18 Aug 2006 10:18 PM

Erland Sommarskog

New (mit***@viraat.com) writes:

> i had read in msdn about sql debugger for debugging of stored procedures
> and queries. but i am not able to find the sql debugger tools. can
> anyone give some idea about the same.

If you are on SQL 2005, debugging is only possible from Visual Studio
(and probably not all editions of VS.)

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx