Chandrashekar
12/2/2016 - 9:05 AM

LINKED SERVER RETURNED MESSAGE “QUERY TIMEOUT EXPIRED”

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