Query governor in SQL Server

Query governor cost limit:

This option is used to set the time to be taken to execute a query.
If the value is 0, then the time limit is indefinite. Where as, if we provide
positive value. The query will be executed upto that particular time.

For server level settings [For all the users]:
If we want to set this value for the whole server irrespective of the users, we can acheive it using
sp_configure option.
sp_configure 'QUERY_GOVERNOR_COST_LIMIT',1
reconfigure

Whereas, If we need to set the same for specific connection. We can use the set command.

SET QUERY_GOVERNOR_COST_LIMIT 1 Thanks and Regards,
Venkatesan Prabu .J