Debug tool

Hi!
What is the best tool for debugging stored procedures and functions?Hi
I don't rely on debuggin tools.
All work I do in QA.
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> Hi!
> What is the best tool for debugging stored procedures and functions?
>|||Uri,
I hope I understand what you mean, but it require hard coding to trace what
is happaning.
I've heard that VS can do it by using additional components.
"Uri Dimant" <urid@.iscar.co.il> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:OsTrLotnDHA.2364@.TK2MSFTNGP11.phx.gbl...
> Hi
> I don't rely on debuggin tools.
> All work I do in QA.
> "Dmitry Karneyev" <karneyev@.msn.com> wrote in message
> news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> > Hi!
> >
> > What is the best tool for debugging stored procedures and functions?
> >
> >
>|||Dmitry,
In case Uri Dimant's answer was a little abbreviated.
QA = Query Analyser - <right><click> on Stored Proc, and choose debug in SQL2000.
Some versions of Visual Studio (.Net) can do this too, but QA is always available.
For SQL Server 7, Visual Studio 6 sometimes works, especially if you hold
your mouth right and sacrifice three chickens.
Regards
AJ
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> Hi!
> What is the best tool for debugging stored procedures and functions?
>|||QA is the best.........
--
Shaju Thomas
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> Hi!
> What is the best tool for debugging stored procedures and functions?
>|||Andrew
You are right.
Although there is such tool avaliable I perefer to debug in QA (I mean by
running piece of code of sp)
I've just got used to do it.
"Andrew John" <aj@.DELETEmistrose.com> wrote in message
news:OPaCZztnDHA.424@.TK2MSFTNGP10.phx.gbl...
> Dmitry,
> In case Uri Dimant's answer was a little abbreviated.
> QA = Query Analyser - <right><click> on Stored Proc, and choose debug in
SQL2000.
> Some versions of Visual Studio (.Net) can do this too, but QA is always
available.
> For SQL Server 7, Visual Studio 6 sometimes works, especially if you hold
> your mouth right and sacrifice three chickens.
> Regards
> AJ
> "Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> > Hi!
> >
> > What is the best tool for debugging stored procedures and functions?
> >
> >
>|||Thanks Andrew!
I managed to use QA Debugger. It's pretty simple!
Now the question is: how to use VS.NET Ent to debug stored procedures?
"Andrew John" <aj@.DELETEmistrose.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:OPaCZztnDHA.424@.TK2MSFTNGP10.phx.gbl...
> Dmitry,
> In case Uri Dimant's answer was a little abbreviated.
> QA = Query Analyser - <right><click> on Stored Proc, and choose debug in
SQL2000.
> Some versions of Visual Studio (.Net) can do this too, but QA is always
available.
> For SQL Server 7, Visual Studio 6 sometimes works, especially if you hold
> your mouth right and sacrifice three chickens.
> Regards
> AJ
> "Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> > Hi!
> >
> > What is the best tool for debugging stored procedures and functions?
> >
> >
>|||Dmitry,
Sorry, I can't help - I've only got the 2003 Pro version.
AJ
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message news:er1nI5tnDHA.2488@.TK2MSFTNGP12.phx.gbl...
> Thanks Andrew!
> I managed to use QA Debugger. It's pretty simple!
> Now the question is: how to use VS.NET Ent to debug stored procedures?
> "Andrew John" <aj@.DELETEmistrose.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
> news:OPaCZztnDHA.424@.TK2MSFTNGP10.phx.gbl...
> > Dmitry,
> >
> > In case Uri Dimant's answer was a little abbreviated.
> >
> > QA = Query Analyser - <right><click> on Stored Proc, and choose debug in
> SQL2000.
> > Some versions of Visual Studio (.Net) can do this too, but QA is always
> available.
> >
> > For SQL Server 7, Visual Studio 6 sometimes works, especially if you hold
> > your mouth right and sacrifice three chickens.
> >
> > Regards
> > AJ
> >
> > "Dmitry Karneyev" <karneyev@.msn.com> wrote in message
> news:ORUh7ktnDHA.372@.TK2MSFTNGP11.phx.gbl...
> > > Hi!
> > >
> > > What is the best tool for debugging stored procedures and functions?
> > >
> > >
> >
> >
>