sql server 2005 enterprise query wont stop

one query wont stop executing

how to stop query

using sql server 2005 enterprise

Who is Participating?
Aneesh RetnakaranDatabase AdministratorCommented:
there is Stop button in the tool bar (its red)
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.
rgb192Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.