Unable to place buffer 0x%lx holding logical page %ld in sdes for object '%.*s'žeither there is no room in sdes or buffer already in requested slot.
Under certain rare circumstances, a select-based insert of the following form:
insert into tblDestinationData select tblSourceData.* from tblSourceData
on a table with two or more nonclustered indexes can result in an 803 session descriptors (sdes) error condition. This error is dependent on the data in the indexes at the time the operation was attempted.
This condition can generally be corrected by dropping all nonclustered indexes in the table, and then retrying the option. If the action succeeds, the indexes can then be re-created.