0

A scheduled job step ran DBCC CHECKTABLE on a table but returned the following error:

Cannot continue the execution because the session is in the kill state. [SQLSTATE HY000] (Error 596). The step failed.

What causes this error?

Dale K
  • 429
  • 1
  • 3
  • 17
user2368632
  • 1,133
  • 1
  • 15
  • 33

2 Answers2

2

Many things cause a session to enter a kill state. If other user kills your session, or if running command throws an error which severity needs terminate the connection (check this for more info https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities?view=sql-server-ver15)

When CHECK* commands result in this, ins most cases is because it triggers some error with severity 19 or higher. Can be your table corrupted or just a space problem. You must investigate further to more details.

Rodrigo
  • 109
  • 1
  • 5
1

After poking around, discovered that the volume was very low on space so probably didn't meet the free space requirements for "dbcc checktable".

user2368632
  • 1,133
  • 1
  • 15
  • 33