Creating a resource limit

Create a new resource limit using sp_add_resource_limit:

sp_add_resource_limit name, appname, rangename, limittype, limit_value, enforced, action, scope

See sp_add_resource_limit in the Reference Manual: Procedures.