VB.Net 2005 ADO.Net, SQL Server 2008 R2: Error:" Cannot create new transaction because capacity was exceeded."
VB.Net 2005 windows forms application using ADO.Net. Linked to a SQL Server 2008 R2 database with approximately 2,000,000 records. Table throwing error has approximately 48000 records. Attempting to add a record to this table sometimes results in error: "Cannot create new transaction because capacity was exceeded."
Usually after three attempts the error disappears and record is added successfully. Please help me solve this issue that seems to only occur on this table. Thank you.