master.sys.xp_DirTree RRS feed

  • Question

  • I have 25,000 subfolders under parent directory. when i try to run following query it will not display any folders with 25,000 subfolders but i  run with 2000 subfolders it displays all the subfolders. is there any limit on the subfolders to use below query. Any help much appreciated

    EXEC master.sys.xp_DirTree 'maindirectorypath’


    Thursday, June 19, 2014 6:58 PM


All replies