Line 1: Incorrect syntax near ‘)’.
/Forums/search.asp, line 447
This error indicates a problem with the SQL query itself and defragging won’t resolve the issue. Has anyone changed the query related to the search lately? If not this could also be an issue with some bad data.
What ever it is the query is violating the rules of SQL.
Without seeing the actual query being run that’s as far as I can get with this.
I think it has to do with the seek times on the drive.. Could be wrong here, but thats why I suggested Defrag (to reorganize the databases)… Was just one mans opinion here…