Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mufasa
Yak Posting Veteran
62 Posts |
 Posted - 2006-03-09 : 11:00:06
|
| Can anyone explain how to get rid of this error?The table I am reading from has over 12 million records, I am trying to update my table with only the last 4 weeks, about 60k records.ThanksErrorServer: Msg 7399, Level 16, State 1, Line 5OLE 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.].statement:delete dbo.DYDFILFROM dbo.DYDFIL INNER JOIN dbo.[This Year Last Year1] ON dbo.DYDFIL.dyd_date >= dbo.[This Year Last Year1].[4WKCivil]insert into DYDFILSELECT TOP 100 PERCENT RIGHT('000000' + RTRIM(CONVERT(CHAR(15), DYDFIL.dyd_emp_code)), 6) AS EmpCode, DYDFIL.*FROM [CANMTLSQL03].MEXX.dbo.DYDFIL DYDFIL INNER JOIN dbo.[This Year Last Year1] ON DYDFIL.dyd_date >= dbo.[This Year Last Year1].[4WKCivil] |
|
|
|
|
|
Resource limit was reached