How to set the query governor cost limit option (Enterprise Manager)
SQL Server 2000
To set the query governor cost limit option
- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Server Settings tab.
- Under Server behavior, select or clear the Use query governor to prevent queries exceeding specified cost check box.
If you select this check box, in the spin box, enter a nonzero, nonnegative value, which the query governor uses to disallow execution of any query with a running length exceeding that value.