Home Forums SQL Server 2008 SQL Server 2008 - General Getting "OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired"." RE: Getting "OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired"."

  • May 12, 2010 at 11:49 am

    #1166431

    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.

    With Thanks and Regards
    Arshad Ali
    Microsoft India

    My Blog - http://arshadali.blogspot.com/[/url]