Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-11 : 07:12:01
|
| Roy writes "After doing a number of checks to determine the size of a large recordset (say 40000 records) returned by a query (eg by using Select count(*)...) a user still manages to submit it. Then he wants to abort but has to wait until all the data has been sent to the application.Can one abort a query like this in an application written in VB? Similar to the Query Analyzer's Cancel Execution button." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-11 : 08:17:48
|
| AFAIK you can only kill it from the server end. Once the request has been passed that's it until the data is returned (or not) to the application. It's essentially a blocking call on the part of the app and nothing else will happen.-------Moo. :) |
 |
|
|
|
|
|
Aborting an SQL query which returns a large record set