RECURSION_ROW_LIMIT - how to increase more than 1M ?

saurabh_aher
New Contributor III

‎07-30-2025 11:47 PM

 

I have usecase where we requires rows more than 1M. buts recursion is limited to 1M. how to increase this limit in Recursive CTE ? 

saurabh_aher_0-1753944326907.png

saurabh_aher_1-1753944347987.png

 

 

0 Kudos