i have a  cursor that execute all my views in sp_refreshview

and then my output is the views that cant run .

now, my new challenge is how to run it in...

tnx!!!!!!!

i thought about this  : 

select id
into #temp1
from purchases
where year=2015

select id
into #temp2
from purchases
where year<>2015

select id
from #temp1
where not...