1 row insert in specific table timeout
Posted on 2007-08-07
I have an ASP web application which has been running for the past 2 years with no problems. Today it started giving a timeout error when inserting 1 row into a table. Other inserts into tables are running fine.
Error: -2147217871 / [Microsoft][ODBC SQL Server Driver]Timeout expired / Microsoft OLE DB Provider for ODBC Drivers
Related SQL statement: insert into pchldr (plcyid_ph, lastname_ph, firstname_ph, address1_ph, address2_ph, city_ph, state_ph, zip_ph, county_ph) values (137305,'TEST','TEST','test','test','test','TS','55555','Test')
Description: [Microsoft][ODBC SQL Server Driver]Timeout expired
Help context: 0
Native error: 0
Error number: -2147217871
Error source: Microsoft OLE DB Provider for ODBC Drivers
SQL state: S1T00
Any thoughts on what could cause this simple insert to start failing all of the sudden? The table has a Key on an ID field and only about 22K records in it.