Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: Linked Servers - Timeouts

    I have a basic UPDATE that's something along the lines of:

    Code:
    UPDATE LocalTable SET LocalColumn = RemoteColumn
    FROM LocalTable INNER JOIN server.catalog.dbo.RemoteTable ON (...)
    After running in Query Analyzer for ten minutes, I get:

    Server: Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.
    [OLE/DB provider returned message: Timeout expired]
    OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].

    I checked the linked server settings in EnterpriseManager and both timeout settings are at 0 (no timeout). Any idea how I can remove whatever timeout is causing this?

    Anyone know how remote join performance compares to moving remote data over via DTS, running an UPDATE, and dropping the data?

  2. #2
    Join Date
    Oct 2003
    Posts
    268
    Found the answer in old archived forums:

    sp_configure @configname='remote query timeout (s)', @configvalue=0

    Thanks everyone!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •