Execution time

Hi
When I run an sp or a complex query in the query analyzer, it shows a world
spining and an execution time at the bottom while the query is still
working.
Is there a way to get that execution time so I can show it inside a program
code like Delphi?
How does that counter work?
Also for the world pic.
ThanksIt's just a counter. It's not generated by SQL Server, it's purely within
Query Analyzer. It starts ticking when QA submits the query and ends when
the query returns.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Gonzalo Torres" <condormix2001@.yahoo.com.mx> wrote in message
news:uPZomUi4EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> When I run an sp or a complex query in the query analyzer, it shows a
world
> spining and an execution time at the bottom while the query is still
> working.
> Is there a way to get that execution time so I can show it inside a
program
> code like Delphi?
> How does that counter work?
> Also for the world pic.
> Thanks
>|||Gonzalo Torres wrote:
> Hi
> When I run an sp or a complex query in the query analyzer, it shows a
> world spining and an execution time at the bottom while the query is
> still working.
> Is there a way to get that execution time so I can show it inside a
> program code like Delphi?
> How does that counter work?
> Also for the world pic.
> Thanks
You'll need to run your query asychronously from Delphi and then you can
just update a running counter and show any fancy graphic you need to
keep the user interested.
--
David Gugick
Imceda Software
www.imceda.com