Dropping resource limits

Use sp_drop_resource_limit to drop a resource limit from an Adaptive Server.

The syntax is:

sp_drop_resource_limit {name , appname } [, rangename, limittype, enforced, action, scope]

Specify enough information to uniquely identify the limit. You must specify a non-null value for either name or appname. In addition, specify values according to those shown in Table 6-3.

**Table 6-3: Identifying resource limits to drop**
Parameter	Value specified	Consequence
name	Specified login	Drops limits that apply to the particular login.
name	NULL	Drops limits that apply to all users of a particular application.
appname	Specified application	Drops limits that apply to a particular application.
appname	NULL	Drops limits that apply to all applications used by the specified login.
timerange	An existing time range stored in the systimeranges system table	Drops limits that apply to a particular time range.
timerange	NULL	Drops all resource limits for the specified name, appname, limittype, enforcement time, action, and scope, without regard to rangename.
limittype	One of the three limit types: row_count, elapsed_time, io_cost	Drops limits that apply to a particular limit type.
limittype	NULL	Drops all resource limits for the specified name, appname, timerange, action, and scope, without regard to limittype.
enforced	One of the enforcement times: pre-execution or execution	Drops the limits that apply to the specified enforcement time.
enforced	NULL	Drops all resource limits for the specified name, appname, limittype, timerange, action, and scope, without regard to enforcement time.
action	One of the four action types: issue warning, abort query batch, abort transaction, kill session	Drops the limits that apply to a particular action type.
action	NULL	Drops all resource limits for the specified name, appname, timerange, limittype, enforcement time, and scope, without regard to action.
scope	One of the scope types: query, query batch, transaction	Drops the limits that apply to a particular scope.
scope	NULL	Drops all resource limits for the specified name, appname, timerange, limittype, enforcement time, and action, without regard to scope.

When you use sp_droplogin to drop an Adaptive Server login, all resource limits associated with that login are also dropped.

For detailed information, see sp_drop_resource_limit in the Reference Manual.