INF: Improved KILL Statement for DBCC CHECKDB (167608)


The information in this article applies to:

  • Microsoft SQL Server 6.5 Service Pack 3 and later
This article was previously published under Q167608

SUMMARY

Starting with SQL Server version 6.5 Service Pack 3, the Transact-SQL KILL statement works more reliably for DBCC CHECKDB.

MORE INFORMATION

Previously, DBCC NEWALLOC reliably responded to the KILL statement, but CHECKDB did not. For a brief period after submitting the DBCC CHECKDB command, it did respond, but after a few minutes (the exact period of time varies), it stopped responding.

Starting with SQL Server 6.5 Service Pack 3, the KILL statement terminates a DBCC CHECKDB process more consistently. A certain (and unpredictable) amount of time may elapse between issuing the KILL statement and the termination of the process, but this interval is usually less than 60 seconds.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbusage KB167608
©2003 Microsoft Corporation. All rights reserved.