Solomon Rutzky takes us through a couple of undocumented additions to SQL Server 2019:
SQL Server 2019 introduced, among other things, two new filesystem-related items:
1. a system stored procedure,
sys.xp_delete_files(), and
2. an instance-level configuration option,'allow filesystem enumeration'Both are undocumented, so let’s see if we can figure out what they do.
Click through to see how both work.