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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-11 : 14:11:19
|
| phil writes "While searching for "DTS package in job step", I received a Timeout Expired error on /forums/search.asp, line 180.(I captured the HTML, but it's too much for this field.) Since I get this error from time to time in my applications, I'd like to know the usual troubleshooting steps that you employ when you encounter this error.TIA for your time." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-09-11 : 14:30:22
|
| I limit potential search options or enhance indexes to provide better performance. Unfortunately Graz is restricted by his hosting service in the things he can do (e.g. no Full-text indexes). I'm guessing you got a timeout on the Forum Search because you went with the default settings of "ALL Forums, All Dates" and probably even got a lot of hits. Might I suggest that you narrow the scope of your search by date or by forum.Oh, one other solution to general problem... in code, such as ASP, use RS.GetRows or RS.GetString instead of the oft-imitated Do While NOT RS.EOF... Loop |
 |
|
|
philh
Starting Member
18 Posts |
Posted - 2002-09-13 : 12:13:16
|
| Problem I have, Mark is:1) I use coldFusion. No recordsets, just query returns. The error occurs before I get anything back to process.2) I get this error on the simplest, shortest queries imaginable. On exquisitely-indexed, small tables.TIA for your input,Phil HegedusichSenior Web DeveloperIIMAKhttp://www.iimak.comThe best thermal transfer printer ribbons on the planet |
|
|
|
|
|
|
|
|
Timeout Expired on SQLTeam Forum?