Overrides the currently configured value for the current connection.
SET QUERY_GOVERNOR_COST_LIMIT value
Using SET QUERY_GOVERNOR_COST_LIMIT applies to the current connection only and lasts the duration of the current connection. Use the query governor cost limit option of sp_configure to change the server-wide query governor cost limit value. For more information about configuring this option, see sp_configure and Setting Configuration Options.
The setting of SET QUERY_GOVERNOR_COST_LIMIT is set at execute or run time and not at parse time.
SET QUERY_GOVERNOR_COST_LIMIT permissions default to members of the sysadmin fixed server role.
SET |