Open Source Content Management

Rapidinha SQL SERVER

Erro :

OLE DB provider "SQLNCLI10" for linked server  returned message "Query timeout expired".

Verificando ambiente :

SELECT * FROM sys.configurations WHERE name='remote query timeout (s)'

Solucionando Problema :

sp_configure 'remote query timeout',3600

go 

reconfigure with override 

go

Obs : Tempo em segundos 3600' = 1 hora