Change the 'remote query timeout' value to zero for one of our Azure SQL Database

Question

We are required to change the 'remote query timeout' value to zero for one of our Azure SQL Database but not able to find any way to implement this change. For example, we can do it in SQL VM instance by using sp_configure system procedure but this cannot be used in Azure SQL database. Could you please confirm if mentioned remote query option can be changed for Azure SQL database or there is workaround to achieve this purpose.

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

‘remote query timeout’ configuration option can’t be changed in Azure SQL DB; because sp_configure system stored procedure is not supported in Azure SQL DB as mentioned below in

https://learn.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server?view=azuresql#t-sql-syntax-not-supported-in-azure-sql-database

Also the option would not help for query timeout errors you might getting when running the queries on Azure SQL DB; as this option is for outbound queries from DB’s perspective (ex: linked servers), while the queries received by DB would be inbound queries as mentioned below in Configure the remote query timeout (server configuration option) - SQL Server | Microsoft Learn documentation.

Regards

Geetha