Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/106010

From BetaArchive Wiki

FIX: Error 816 When Many Updates Performed

PSS ID Number: Q106010 Article last modified on 10-31-1994



The information in this article applies to:
- Microsoft SQL Server version 4.2

BUG# NT: 513 (4.2)


When there are many updates performed in a database configured with low open objects, SQL Server will give error 816, level 20, state 4:

Process %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES. The SQL Server is terminating this process.

The following warnings will also be received:

pss found with open sdes

process being freed while holding Dataserver semaphore

In some cases, after cycling SQL Server, any attempt to create or drop a table in the database will result in a 816 error and be disconnected.


The server is configured with a low configuration for open objects (100). The error 816 happens when the tran log is full and several ‘dump tran with no_log’ are issued.


Increase the configuration for open objects.


Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. This problem was corrected in SQL Server version 4.21. For more information, contact your primary support provider.

Additional reference words: 4.20 configuration Windows NT KBCategory: kbother kberrmsg KBSubcategory: SSrvWinNT


Copyright Microsoft Corporation 1994.