Does SQL Server query timeout settings change require a server restart? I'm trying to execute a query that times out after 10 minutes. From experience I know that the query takes about 18 minutes to execute. It's not ideal, and this is being worked on, however for now I just need it to execute.

Having changed the Remote query timeout parameter to 0, however, the query is STILL timing out after 10 minutes. I get the message:

The statement has been terminated.
Msg -2, Level 11, State 0, Line 16
Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.


This is using SSMS on a remote computer. Why is the timeout setting not taking effect? Do I need to restart the server? (This isn't possible right now)
According MS-DOCS you don't need to restart SQL Server.

Configure the remote query timeout Server Configuration Option


  Follow Up: After you configure the remote query timeout option
  
  The setting takes effect immediately without restarting the server.