The query has been canceled because the estimated cost of this query () exceeds the configured threshold of 1000.
Error: The query has been canceled because the estimated cost of this query () exceeds the configured threshold of 1000. Contact the system administrator. Cause: QUERY_GOVERNOR_COST_LIMIT - Is a numeric or integer value specifying the longest time in which a query can run. "Query cost" refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration. Workthrough: GO EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE ; GO EXEC sp_configure 'query governor cost limit', 6000 ; GO RECONFIGURE; GO