Use sp_modify_resource_limit to specify a new limit value or a new action to take when the limit is exceeded or both. You cannot change the login or application to which a limit applies or specify a new time range, limit type, enforcement time, or scope.
The syntax of sp_modify_resource_limit is:
sp_modify_resource_limit name, appname, rangename, limittype, limitvalue, enforced, action, scope
To modify a resource limit, specify the following values:
You must specify a non-null value for either name or appname.
To modify a limit that applies to all users of a particular application, specify a name of “null.”
To modify a limit that applies to all applications used by name, specify an appname of “null.”
To modify a limit that governs a particular application, specify the application name that the client program passes to the Adaptive Server in the login packet.
You must specify non-null values for rangename and limittype. To uniquely identify the limit, specify non-null values for action and scope.
Specifying “null” for limitvalue or action indicates that its value does not change.
For detailed information, see sp_modify_resource_limit in the Reference Manual.
