Microsoft KB Archive/167608

= INF: Improved KILL Statement for DBCC CHECKDB =

Article ID: 167608

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Service Pack 3

-



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.

Keywords: kbusage KB167608

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.