sysresourcelimits

master database only

Description

sysresourcelimits contains a row for each resource limit defined by Adaptive Server. Resource limits specify the maximum amount of server resources that can be used by a Adaptive Server login or an application to execute a query, query batch, or transaction.

Columns

The columns for sysresourcelimits are:

Name	Datatype	Description
name	varchar(30) null	Login name
appname	varchar(30) null	Application name
rangeid	smallint	id column from systimeranges
limitid	smallint	id column from spt_limit_types
limitvalue	int	Value of limit
enforced	tinyint	Subset of the enforced column from spt_limit_types: 1 = prior to execution 2 = during execution 3 = both
actiontotake	tinyint	Action to take on a violation: 1 = issue warning 2 = abort query batch 3 = abort transaction 4 = kill session
scope	tinyint	Scope of user limit (a bitmap indicating one or more of the following): 1 = query 2 = query batch 4 = transaction
spare	tinyint	Reserved

Indexes

Clustered index On name, appname