Posted by NRBOMMA on 02/02/07 20:06

On Feb 2, 3:18 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Jeff Kish (kishjj...@charter.net) writes:
> > I am under the understanding that having the sql server 2005 db is not
> > enough (like 2000 was) to debug stored procedures.. that I need to
> > purchase (costly) visual studio 2005.
>
> > Can someone suggest a free or lower cost alternative?
>
> > sorry to be so cheap.. its the times I think.
>
> PRINT and SELECT is what I use, even in SQL 2000. I used to use the
> T-SQL debugger occasionally, but I gave up on it. There were so many stars
> that had to be aligned for it to work.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

~
T-Sql debugger is some what okay, I used very long back.
I'm very comfortable with Print and Select commands to debug a stored
procedure.

~NR

• Next in forum: Re: Querying towards a responsive UI
• Prev in forum: Re: SQL Slow from MSDE 2000 to SQL Express
• Thread view: Re: any way to debug stored procedures without buying visual studio?

[Reply to this message]