odbc sql server driver timeout expired sql server 7.0 
Author Message
 odbc sql server driver timeout expired sql server 7.0

I am trying to run a big query and this mesage appears after about 20 seconds..any ideas?
I increased the value of the tiomeout to the max (30000)
it is a pretty big query:
UPDATE telemanagerserver.dbo.Customers
SET dncgov = 1
WHERE  CombPhone IN
        (SELECT number
      FROM dncgov.dbo.fulllist
)

customer has 140 thousand records
fulllist has 52 million records

indexes on combphone and on number
two different databases on the same server

I also tried
UPDATE telemanagerserver.dbo.Customers
SET dncgov = 1
WHERE  exists         (SELECT number
      FROM dncgov.dbo.fulllist Where CombPhone = Number)

and

Select Number into #temp
 from dncgov.dbo.fulllist
 Inner Join telemanagerserver.dbo.Customers
  on Number = Combphone

then

UPDATE telemanagerserver.dbo.Customers
SET dncgov = 1
WHERE  exists         (SELECT number
      FROM #temp Where CombPhone = Number)

they all timeout

any ideas?



Fri, 14 Apr 2006 20:11:04 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. [ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Timeout expired]

2. SQL 2000 [Microsoft][ODBC SQL Server Driver]Timeout expired

3. java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Timeout expired

4. category:odbc,source:odbc sql server driver,number:s1t00(timeout expired)

5. ODBC SQL Server Driver: Timeout Expired (80040e31)

6. [ODBC SQL Server Driver]Timeout expired

7. [ODBC SQL Server Driver]Timeout expired

8. ?[microsoft][ODBC SQL Server Driver] Timeout expired

9. [ODBC SQL Server Driver]Timeout expired

10. [ODBC SQL Server Driver]Timeout expired

11. S1T00: [Microsoft][ODBC SQL Server Driver] Timeout Expired

12. Warning State: S1T00,Native:0, Origin: [Microsoft][ODBC SQL Server Driver] timeout expired


 
Powered by phpBB® Forum Software