Use sp_drop_resource_limit to drop a resource limit from an SAP ASE.
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.