Microsoft KB Archive/69131

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2

-

Rollbacks will be done implicitly by the data server when a transaction aborts. The errors that could cause a transaction to abort can be broadly divided into the following three categories:

Resource Errors

 * Running out of system resources

General Errors

 * Running out of space in the log
 * Deadlock conditions
 * Protection exceptions; that is, not having the right permissions on an object
 * Inability to run a stored procedure
 * Unable to read/write a stored procedure or trigger from sysprocedures or the cache
 * Exceeding the maximum nesting levels (32) of stored procedure executions
 * Errors detected by the checkpoint process
 * Some overflow errors
 * Errors encountered by the checkpoint process

Utility Errors
  Any errors encountered by the following commands:

     alter database alter table bulk copy create database create index create table dbrepair index disk init disk refit drop object drop index drop database create object (view, table, trigger, procedure, rule) update statistics truncate table create unique index 

Additional query words: Server Transaction processing

Keywords : kbother SSrvErr_Log SSrvServer

Version : 4.2

Platform : OS/2

Issue type :
 * }