https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104967&feed=atom&action=historyMicrosoft KB Archive/104967 - Revision history2024-03-28T12:42:19ZRevision history for this page on the wikiMediaWiki 1.39.3https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104967&diff=431517&oldid=prevX010: X010 moved page Microsoft KB Archive/Q104967 to Microsoft KB Archive/104967 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/"2020-08-12T18:13:41Z<p>X010 moved page <a href="/wiki/index.php?title=Microsoft_KB_Archive/Q104967&action=edit&redlink=1" class="new" title="Microsoft KB Archive/Q104967 (page does not exist)">Microsoft KB Archive/Q104967</a> to <a href="/wiki/index.php?title=Microsoft_KB_Archive/104967" title="Microsoft KB Archive/104967">Microsoft KB Archive/104967</a> without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en-GB">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">ā Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:13, 12 August 2020</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en-GB"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>X010https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104967&diff=237234&oldid=prev3155ffGd: importing KB archive2020-07-18T17:49:58Z<p>importing KB archive</p>
<p><b>New page</b></p><div>FIX: 803 Error on Select Based Insert<br />
<br />
PSS ID Number: Q104967 Article last modified on 10-31-1994<br />
<br />
4.20<br />
<br />
OS/2<br />
<br />
{|<br />
|width="98%"| The information in this article applies to:<br />
|-<br />
| - Microsoft SQL Server version 4.2 for OS/2<br />
|}<br />
<br />
BUG# OS/2: 1692 (4.2)<br />
<br />
= SYMPTOMS =<br />
<br />
Under certain rare circumstances, a select-based insert can receive an 803 error:<br />
<br />
Unable to place buffer 0x%ld holding logical page %ld in sdes for object ā%sā - either there is no room in sdes or buffer already in requested slot.<br />
<br />
Under rare circumstances, an insert of the form:<br />
<br />
insert table803 select * from source_table<br />
<br />
on a table with two or more non-clustered indexes can result in an 803 error. This error is very dependent on the data in the indexes at the time the operation is attempted.<br />
<br />
= WORKAROUND =<br />
<br />
This condition may sometimes be addressed by dropping any non-clustered indexes on the table, then retrying the operation. If it succeeds, the indexes can be recreated and normal operations continued.<br />
<br />
= STATUS =<br />
<br />
Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. This problem was corrected in SQL Server version 4.2aK11. For more information, contact your primary support provider.<br />
<br />
Additional reference words: 4.20 KBCategory: kbother kberrmsg KBSubcategory: SSrvServer<br />
<br />
=============================================================================<br />
<br />
Copyright Microsoft Corporation 1994.</div>3155ffGd