Dropping Resource Limits

Use sp_drop_resource_limit to drop a resource limit from an SAP ASE.

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.

See sp_drop_resource_limit in the Reference Manual: Procedures.