Refresh the metadata for every view in the database.
SET NOCOUNT ON
DECLARE @SQL varchar(max) = ''
SELECT @SQL = @SQL + 'print ''Refreshing --> ' + u.name + '.' + o.name + '''
EXEC sp_refreshview [' + u.name + '.' + o.name + '];'
FROM sysobjects o inner join sysusers u on o.uid=u.uid WHERE type = 'V' order by u.name
EXEC(@SQL)
go