Debug sp in Query Analyzer

Hi all,
Is it possible to debug sp in client workstation by using sql query
analyzer? how?
It's only work to me when debug sp in the SQL server by using sql query
analyzer
Thanks in advance!!
MartinNo it is possible only from Query Analyser
Madhivanan|||it means that the Query Analyser and the SQL server must be within the same
machine, rite?
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1122472249.786547.271590@.z14g2000cwz.googlegroups.com...
> No it is possible only from Query Analyser
> Madhivanan
>|||Yes
Madhivanan|||thx!
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1122476462.825295.300700@.z14g2000cwz.googlegroups.com...
> Yes
> Madhivanan
>|||No - you can have Query Analyzer on one machine, and the SQL server instance
on another machine, and still debug a stored procedure (I just debugged a
stored procedure on our development server from my own workstation to verify
this). You do need to have the SQL Server properly configured, but Query
Analyzer does not need to be run from the same machine as the SQL server
instance.
"Atenza" <Atenza@.mail.hongkong.com> wrote in message
news:ufjA2ZrkFHA.3436@.tk2msftngp13.phx.gbl...
> it means that the Query Analyser and the SQL server must be within the
same
> machine, rite?
>
> "Madhivanan" <madhivanan2001@.gmail.com> wrote in message
> news:1122472249.786547.271590@.z14g2000cwz.googlegroups.com...
>|||what do you mean by: 'You do need to have the SQL Server properly configured
,
but Query Analyzer does not need to be run from the same machine as the SQL
server instance.'? What do I need to configure differently on the sql serve
r
so that developers can use the debug feature from their work stations?
"Jeremy Williams" wrote:

> No - you can have Query Analyzer on one machine, and the SQL server instan
ce
> on another machine, and still debug a stored procedure (I just debugged a
> stored procedure on our development server from my own workstation to veri
fy
> this). You do need to have the SQL Server properly configured, but Query
> Analyzer does not need to be run from the same machine as the SQL server
> instance.
> "Atenza" <Atenza@.mail.hongkong.com> wrote in message
> news:ufjA2ZrkFHA.3436@.tk2msftngp13.phx.gbl...
> same
>
>