﻿--Migration
DECLARE @sql nvarchar(max) = ''

SELECT @sql += 'EXEC sp_refreshview ''dbo.' + [name] + '''' + char(13) + char(10) 
FROM sys.views
WHERE schema_id = 1 /*dbo*/
  AND [name] like '%_OSSZES'

EXEC sp_executesql @sql
GO

