Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

KILL SELECT process

Status
Not open for further replies.
Hablaras

Hablaras

Programmer
Joined
Oct 10, 2003
Messages
22
Location
NL
Why is it not possible to KILL a SELECT process? The BOL states this is one of several process that can't be killed.

If users are retrieving vast amounts of data, taking up to many resources, those processes can't be killed?

What's the risk? That users receive partial result sets?

Has anyone any ideas on this subject?
 
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
750
grnzbra
grnzbra
Auguy
  • Locked
  • Question Question
Using UDF In Select, Bad Idea?
Replies
3
Views
556
Auguy
Auguy
grnzbra
  • Locked
  • Question Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top