Asynchronous sqlserver

Question

how can i use Asynchronous queries in sqlserver 2005 & asp (not .net)

Answer 1

ADO connection and recordset support asynchronous behavior, (look at this and this), however if your query returns data to the client, it may not make sense to use async behavior. You should consider using AJAX on the HTML side to launch queries and poll for results.