Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.sqlserver.programming,microsoft.public.excel.programming
|
|||
|
|||
Server timeout expired
A query (containing 4 left outer joins) takes above 6 minutes to
return a recordset of 212 rows. I am passing a sql string from MS Excel 2003 to MS Sql Server 2000 to run the query and return the recordset to a spreadsheet. I get the message "Timeout expired" from Excel. The database is from a legacy application which keeps transaction data in separate tables for each financial year. Hence, to use stored procedures would mean having one for each financial year, whereas I can conveniently change the table name in a cell in the spreadsheet based on the year required. Please help. Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") | Excel Worksheet Functions | |||
Timeout Expired | Excel Programming | |||
TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked | Excel Worksheet Functions | |||
Connection with SQL Server generate "Timeout expired" | Excel Programming | |||
COM server timeout | Excel Programming |