The query has been canceled because the estimated cost of this query () exceeds the configured threshold of 1000. Contact the system administrator.

Databases > MS SQL 2012
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.

Resolution:

Overrides the currently configured query governor cost limit value for the current connection.

SET QUERY_GOVERNOR_COST_LIMIT 6000

The setting of SET QUERY_GOVERNOR_COST_LIMIT is set at execute or run time and not at parse time.

Note: increasing the query governor cost is not a good solution, we would recommend to pay more attention to sql statement.