T-SQL script to refresh all VIEWS in DATABASE.
declare c cursor for
select name from sysobjects where type = 'v' and uid = 1
declare @ViewName varchar(500)
fetch next from c into @ViewName
while @@fetch_status = 0
exec sp_refreshView @viewName
fetch next from c into @viewName