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.
sp_modify_resource_limit name, appname, rangename, limittype, limitvalue, enforced, action, scope
See sp_modify_resource_limit in the Reference Manual: Procedures.