The query has been canceled because the estimated cost of this query (302),Contact your Administrator

SET QUERY_GOVERNOR_COST_LIMIT value

Add This Line in Store Procedure


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 limitoption 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 Server Configuration Options.