FIX: Error 803 on INSERT into Table with Multiple Indexes

• Microsoft SQL Server version 6.5

SYMPTOMS

When you insert data into a table that has a clustered index and at least two non-clustered indexes, you may encounter the following error:

Msg 803, Level 20, State 1
Unable to place buffer 0x%lx holding logical page %ld in sdes for
object '%.*s'[ASCII 190]either there is no room in sdes or buffer already in
requested slot.

The SQL Server is terminating this process. DB-Library: Possible network error: Write to SQL Server Failed. Net-Library error 232: ConnectionWrite (WriteFile()).

DB-Library Process Dead - Connection Broken

WORKAROUND

To work around this problem, do either of the following:

• Drop some or all of the non-clustered indexes for the duration of the insert.
  
  -or-



• Drop the clustered index for the duration of the insert.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Keywords          : kbusage SSrvGen 
Version           : 6.5
Platform          : winnt 
Issue type        : 

Last Reviewed: April 8, 1999