Sample Header Ad - 728x90

How to set execution timeout in SSMS

0 votes
3 answers
2060 views
I want to stop all the query that exceeds the given execution timeout value of an instance in SSMS. I tried to set the execution timeout in SSMS using multiple methods. Initially, I tried changing the query execution time through the tools option, as described on the website below. Link Subsequently, I tried a second method from the link. In the tools design settings, we can configure values for the execution timeout in seconds. Link2 However, these methods didn't work even after restarting SSMS. I have also tried to set the execution timeout under the connection properties in the options tab. Unfortunately, this method also failed. The below link says that this setting has some issue. Link3 I want to know how this Execution timeout Setting works. What are the other ways to set this execution timeout in SSMS? My aim is to stop all the long running queries that I will be executing in my SSMS. This setting must work for all the sessions of my SSMS.
Asked by RD Seeker (35 rep)
May 28, 2024, 10:50 AM
Last activity: May 31, 2024, 02:47 PM