LINKED SERVER RETURNED MESSAGE “QUERY TIMEOUT EXPIRED”
SELECT * FROM sys.sysconfigures
WHERE comment ='remote query timeout'
--or
SELECT * FROM sys.configurations
WHERE name='remote query timeout (s)'
sp_configure 'remote query timeout',3600
go
reconfigure with override
go