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 ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
