I have a SQLServer 2000 db. One table is small in terms of its record count (<2200) but has 120 fields. I am only able to successfully run UPDATE, DELETE or INSERT queries before the users are actively running the system. All other tables, which have record counts up to 200K, are able to be updated successfully. However, this one small table returns a timeout error whether the update is run thru the system itself (in VB) or directly on the table using Enterprise Manager, or Query Analyzer to call a related stored procedure.
Please provide any ideas - I have no idea how to fix this one.