I have an issue where things are timing out and I need to get an intermediate fix up while I work on making it faster. I can apparently set Command Timeout on the code side and it will prevent this, but I am wondering if it's possible to set this on the SQL Server side so I can do it without doing a software patch.
"This default value is set by the storage provider. Note that some providers may throw exceptions if this value is set to a non-zero value."
So how could I change the value of Command Timeout via the 'storage provider'? I assume it means SQL Server.