You
can use the Query Governor Cost Limit option to specify the maximum number of
seconds that a query can run. If you specify a nonzero, non-negative value, SQL
Server disallows execution of any query that has an estimated cost exceeding
that value. Specifying 0 (the default) for this option turns off the query
governor, and all queries are allowed to run without any time limit.