State Property (TSqlResult.TSqlError)

An arbitrary number from 1-255 that states "a stale of the error" and is used as a code identifier in the a statement, defaults to 0 if no error but set to 1 in case of an error, normally the code is an indication as to where the error ocured

Syntax

public byte State {get;}

Property Value

The state code.

Remarks

Some error messages can be raised at multiple points in the code for the Database Engine. For example, an 1105 error can be raised for several different conditions. Each specific condition that raises an error assigns a unique state code.

developers can assign any byte value to this property

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

TSqlResult.TSqlError Class
TSqlResult.TSqlError Members