• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

sql server 2005 enterprise query wont stop

one query wont stop executing

how to stop query


using sql server 2005 enterprise

0
rgb192
Asked:
rgb192
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
there is Stop button in the tool bar (its red)
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
Remember that there are some things that will not immediately stop as it will rollback things that it has done in the implicit transaction.

So if you have clicked the red stop button and it is still going, you have to wait until it finishes because it is ensuring transactional consistency.
0
 
rgb192Author Commented:
thanks
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now