>>>So, how can I get the SQL Server session id my query is running in?
>>
>>SELECT @@SPID
>
>Thank you.
>
>So, you say the query that runs the lengthy query should have an asynchronous connection, and the one that reads the advance of the first query should not be asynchronous. What I don get is, in what moment the one that reads the advance should be issued? And how can I know that the lengthy query is completed?

Yes,.... and you can run the query that read the advance whenever (e.g. timer) you want to update the user on its progress

You know when the query is completed when SQLEXEC(nASyncHandle) returns any other values than 0

Walter,