July 15, 2003 at 3:15 pm
Hi
I'm getting a "Time Out Expired" message when printing out customer statements from an application that grabs data directly from it's local MSDE. Everything else prints fine from the printer.
Also we've taken a backup of the database and restored it to another computer printed from the same printer and it works fine.
Checked RAM and Pentium 4 chip seems OK.
Any suggestions??
Cheers
Nathan
July 16, 2003 at 4:47 am
One reason could be that the indexes are out of date.
run sp_updatestats on the database and check whether this makes any difference.
If this does not help then try reindexing the tables.
If this also does not help then one reason could be due to table scans (though this does not explain why it runs fine on another PC). Run sql*trace and see which query is taking time.
Hope this helps
July 18, 2003 at 7:34 pm
Will try your suggestions. Thanks very much.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply