how to Configure or Set query execution timeout from transact SQL

You cannot set that timeout from T-SQL, as this is a client-side setting over which SQL Server has zero control.

Exactly how you set the timeout depends on the API you are using. For instance, in .Net it is a property on the SqlCommand object.

This cannot be done from TSQL.

To fix it from SSMS tool:

1. Update SSMS to 21.6.17 or later, or to SSMS 22.
2. Fix your saved connections. In the Modern connection dialog, open each saved or recent connection's properties and set the execution timeout to 0.
3. Check the global default at Tools then Options then Query Execution then SQL Server then General then Execution time-out = 0.
4. Open new query windows, since existing windows keep the old value.