Modifying Resource Limits

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

See sp_modify_resource_limit in the Reference Manual: Procedures.