Is there a way to determine the command timeout for an executing spid

Question

Is there a DMV or other mechanism available that returns the command timeout for an executing session_id?

Answer 1

The SQL Server database engine has no notion of a command timeout. A query runs until completed, erred, or cancelled by the client application.

Command timeout is implemented entirely by the client API, which cancels the executing command with an attention signal when it runs longer than the specified timeout. This is exactly what happens when you manually cancel a running query in SSMS because it's taking too long.

Consequently, the command timeout is not available on the database server.