Recursive CTE (Common Table Expression) in SQL Server

hi

I have this query in CTE

WITH   cte
AS     (SELECT 1 AS n -- anchor member
        UNION ALL
        SELECT n + 1 -- recursive member
        FROM   cte
        WHERE  n < 50 -- terminator
       )
SELECT n
FROM   cte;

how recursive query execute repetely.

SELECT n + 1 -- recursive member
        FROM   cte
        WHERE  n < 50 -- terminator

thanks and regards

siddu