Chapter 1: Limiting Access to Server Resources

Getting information on existing limits

Use sp_help_resource_limit to get information about existing resource limits.

Users who do not have the System Administrator role can use sp_help_resource_limit to list only their own resource limits.

Users either specify their own login names as a parameter or specify the name parameter as “null.” The following examples return all resource limits for user “joe_user” when executed by joe_user:

sp_help_resource_limit

sp_help_resource_limit joe_user

System Administrators can use sp_help_resource_limit to display the following information:

All limits as stored in sysresourcelimits (all parameters NULL); for example:
```
sp_help_resource_limit
```
All limits for a given login (name is not NULL, all other parameters are NULL); for example:
```
sp_help_resource_limit joe_user
```
All limits for a given application (appname is not NULL; all other parameters are NULL); for example:
```
sp_help_resource_limit NULL, payroll
```
All limits in effect at a given time or day (either limittime or limitday is not NULL; all other parameters NULL); for example:
```
sp_help_resource_limit @limitday = wednesday
```
Limit, if any, in effect at a given time for a given login (name is not NULL, either limittime or limitday is not NULL); for example:
```
sp_help_resource_limit joe_user, NULL, NULL, wednesday
```

For detailed information, see sp_help_resource_limit in the Reference Manual.

Example of listing all existing resource limits

View this book as PDF