MS Sql 2000 table is set to grow unlimited but table failed to accept new INSERTs
Posted on 2007-11-30
using asp page and vbscript i was attempting to INSERT vis sql statement records to a table.
the database was set to grow unlimited and there was over 300 gig of space ont the drive where the mdf files resided. however, i was getting a script timeout when trying to insert a record. the table had about 89000 records in it. after purging the table down to 16000 records, the asp page completed properly and added records.
what reason would cause a table to stop accepting new records?