Sql Server View Refresh

refresh.sql

/* 
refresh sql server database views
*/
declare @name varchar(max) = ''
declare viewCursor cursor
for
select distinct [name]
from [sysobjects]
where [type] = 'V';

open viewCursor
fetch next from viewCursor into @name
while @@FETCH_STATUS = 0
begin
    print 'Refreshing --> ' + @name;
	begin try
		exec sp_refreshview @name;
	end try
	begin catch
		print '  **ERROR Refreshing --> ' + @name;
		print '  ' + ERROR_MESSAGE();
	end catch
    fetch next from viewCursor into @name;
end
close viewCursor
deallocate viewCursor