;WITH CTE AS
( 
 SELECT 
   SCHEMA_NAME(schema_id) as SchemaName,
   objz.type_desc,
   objz.name as ViewName,
   colz.name as ColumnName,
   '' as Description
   from sys.views objz inner join sys.columns colz on objz.object_id=colz.object_id
   where objz.type_desc = 'VIEW'
) 
select 
         'EXEC sys.sp_addextendedproperty
          @name = N''' + ViewName + ''', @value = N''' + REPLACE(convert(varchar(max),[Description]),'''','''''') + ''',
          @level0type = N''SCHEMA'', @level0name = [' + SchemaName + '],
          @level1type = N''VIEW'', @level1name = [' + ViewName + '],
          @level2type = N''COLUMN'', @level2name = [' + ColumnName + '];'
 from CTE
 ORDER BY ViewName, ColumnName