I have been searching for an anser to this but it seems it is not
a commonly used technique.

If I execute a long running sp or query asynchronously from an ASP page
does it survive the page or just end after it finishes ?

For example, if I use this code:

Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText = "spLongRunning"
cmd.CommandType = adCmdStoredProc

' Execute the long running sp asynchconously
cmd.Execute , , adAsyncExecute

After the page has completed, is the sp still running or was it killed ?
And, if I set the cmd to Nothing at the end, does that kill the query or not ?

I guess I could set up some tests but I would like to get som clear
answers to this, preferably some documentation about the behaviour.

Thanks.

PL.