Post reply

linked server error

  • September 6, 2012 at 8:49 pm

    #261581

    Hi,

    any idea how to resolve this. I am getting below error while execuitng a SP that will load the monthly data using linked server. Please advice.

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

  • September 6, 2012 at 10:42 pm

    #1534840

    Looks like the "monthly" data load is a time consuming SP and running over the default "remote query timeout" period which is 10 minutes (600 seconds).

    Try setting this value to a higher or 0 (infinite) and run the query again.

    This is how you can change the remote query timeout:

    [font="Arial Narrow"]sp_configure 'remote query timeout', 0

    go

    reconfigure with override

    go [/font]


    [font="Tahoma"]Fahim Ahmed[/font]
    [font="Times New Roman"]Knowledge is a journey, not a destiny [/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply