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