I have a basic UPDATE that's something along the lines of:
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?Found the answer in old archived forums:
sp_configure @.configname='remote query timeout (s)', @.configvalue=0
Thanks everyone!
Showing posts with label along. Show all posts
Showing posts with label along. Show all posts
Monday, March 19, 2012
servers - Timeouts
Subscribe to:
Posts (Atom)