This extended and undocumented stored procedure can be used to list all folders and subfolders (recursively) from a given directory.  XP_DIRTREE has three parameters:   Directory – This is the directory you pass when you call the stored procedure; for example, ‘D:\Backup_Files’.  Depth – This tells the stored procedure how many subfolder levels to display.  The default … Continue reading What is XP_DIRTREE?  What are the alternatives to XP_Dirtree