INF: Improved KILL Statement for DBCC CHECKDB

ID: Q167608

The information in this article applies to:

Microsoft SQL Server version 6.5 Service Pack 3 and later

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 SSrvGen SSrvTran_SQL 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 9, 1999