Error: "The query has been cancelled because the estimated cost this query(xxx) exceeds the confi (4341455)

Whilst running SQL Query Optimization, the following error occurs (example only):

"The query has been cancelled because the estimated cost this query(3869) exceeds the configured threshold of 3000"

The query governor cost limit has been exceeded. This is a SQL Server configuration setting which is managed by the local DBA using the 'sp_configure' system stored procedure(SP) on the SQL instance.

This is a native SQL Server issue. Contact the DBA of the SQL Instance in question to resolve this.

Alternatively, consult Microsoft Books Online (BOL) or MSDN Library for a full description of the SP "sp_configure" with reference to the configuration setting "query governor cost limit" - maximum setting.

MSDN library home: http://msdn.microsoft.com/en-us/library/default.aspx