Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to set the query governor cost limit option (Enterprise Manager)
Collapse the table of content
Expand the table of content

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

SQL Server 2000

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.

Show:
© 2015 Microsoft