How to set the query governor cost limit option (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set the query governor cost limit option (Enterprise Manager)

To set the query governor cost limit option

  1. Expand a server group.

  2. Right-click a server, and then click Properties.

  3. Click the Server Settings tab.

  4. 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.