The query has been canceled because the estimated cost of this query (302) : Solution

-- Some Times We feels that the query take more time to 

--to execute, and gives user error like given below:

The query has been canceled because the estimated cost of this query (302)

Solution:

CREATE procedure [dbo].[myProc]   
@email varchar(50),   
@password varchar(50)
as
-------------------------------------------------------------------------------------------------------
--when we get Error
--The query has been canceled because the estimated cost of this query (302),Contact your Administrator
SET QUERY_GOVERNOR_COST_LIMIT 0 -- is the important line
--------------------------------------------------------------------------------------------------------
select