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

Jason Handby jasonh at corestar.co.uk
Mon Mar 7 10:25:59 CST 2005


I think it's the SQL server because 
> I tried through enterprise manager:
> 
> SELECT     COUNT(LogID) AS totals
> FROM         IntranetLog
> 
> and EM said that the script timed out.
> 
> Ideas?


Do your tables both have primary keys? If they don't, it could be that time
taken to insert a record is increasing for this reason as the table gets
bigger...?



Jason



More information about the thelist mailing list