Listado de meses entre dos fechas en Sql Server 2016

declare @de date = ‘20170101’

declare @hasta date = ‘20170430’

SET LANGUAGE Spanish;

SELECT  DATENAME(MONTH, DATEADD(MONTH, x.number, @de)) AS Mes

FROM    master.dbo.spt_values x

WHERE   x.type = 'P'      

AND     x.number <= DATEDIFF(MONTH, @de, @hasta);