All we need is an easy explanation of the problem, so here it is.
Is there a DMV or other mechanism available that returns the command timeout for an executing session_id?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
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.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂