Posted by Erland Sommarskog on 02/02/07 10:18

Jeff Kish (kishjjrjj@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, esquel@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

• Next in forum: Re: Ansi SQL92 question
• Prev in forum: Re: How to remove rows where only part of the row is duplicated
• Thread view: Re: any way to debug stored procedures without buying visual studio?

[Reply to this message]