Got it. SET QUERY_GOVERNOR_COST_LIMIT.


>Is there anyway to limit the resource usage on SQL server for a given stored proceedure or for all stored proceedures?
>
>I'd like to be able to protect a production server from "runaway" stored procedures that might consume large resources and bring the rest of the servers requests to a crawl.
>
>Thanks,
>Anthony