[thelist] Weird SQL Server Error - Possibly Just a Timeout

Jay Blanchard jay.blanchard at niicommunications.com
Mon Mar 7 09:58:55 CST 2005

When someone access our Intranet, I record, who, when, and what page
accessed for audit ability. The INSERT sql code has been working
for the past two years. However, this morning it stopped working. I have
tables that this is happening to. Both are averaging about 65,000 rows.
getting script timeouts on INSERT commands. Do you think this is the
and do I increase the script timeout in IIS or the SQL server? I think
the SQL server because I tried through enterprise manager:

SELECT     COUNT(LogID) AS totals
FROM         IntranetLog

and EM said that the script timed out.


Have you made sure that the disc is not full?

More information about the thelist mailing list