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

SET QUERY_GOVERNOR_COST_LIMIT 0

Add This Line in Store Procedure


For More Information Click this Link:
http://sunilsoni1980.blogspot.com/2011/10/query-has-been-canceled-because.html