O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Killing a Process

A SQL Server user process is a task or request made to SQL Server by a user. Occasionally, you might be required to halt (stop) a user process before it completes. Perhaps the user has incorrectly formatted a query or launched a massive transaction that will take hours to complete and has blocked out other users from necessary table information. Whatever the case might be, you can bet that sooner or later someone will ask you to stop her process or someone else will complain about not getting back any information. The proper terminology for halting a process is called killing a process, which sounds much more severe than just halting or stopping the process. When you kill a process, you completely remove the process from SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required