You are here: Re: any way to debug stored procedures without buying visual studio? « MsSQL Server « IT news, forums, messages
Re: any way to debug stored procedures without buying visual studio?

Posted by Jeff Kish on 02/07/07 23:02

On Fri, 2 Feb 2007 10:18:24 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:

>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.
Thanks. I'll give it a try.
The debugger had been fairly nice to use when I had triggers and sp's
to debug.

I assume that it is a simple matter to invoke the procedure (I know
how to compile it) to get things to run?

Regards,
Jeff

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация