sysresourcelimits

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

name

varchar

30

Yes

2

appname

varchar

30

Yes

3

rangeid

smallint

2

No

4

limitid

smallint

2

No

5

enforced

tinyint

1

No

6

action

tinyint

1

No

7

limitvalue

int

4

No

8

scope

tinyint

1

No

9

spare

tinyint

1

No

Name

Attributes

Segment

Columns

csysresourcelimits

clustered

system

name, appname

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo