April 16, 2010 at 2:26 pm
Hi,
We have two servers, backend and frontend. Frontend server has all the data and transformation logics in SSIS (METaL system) and we are executing it from backend server. We have set up linked server across SQL Servers and set Query time property to 0. When we execute this application it works fine for small set of data and completes in 4-5 minutes but starts failing if we run it for huge data set which takes somewhere around 11-12 minutes.
OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired".
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Please help us, it’s becoming a bit critical for us. Thanks in advance.
May 12, 2010 at 9:17 am
Did you get an answer to your problem? We got the same error last night using a linked server. We are looking at increasing the remote_query_timeout setting in SP_configure.
May 12, 2010 at 11:49 am
Yes we resolved it by changing the default value.
Right click on Server in Object Explorer of SSMS, then click on Properties, go to Connection page and change the Remote-Query timeout setting to something more as per your need from 600. You can also specify 0 if you want "no timeout" setting.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply