I'm using SQL Server 2017 Standard.
I want to realize is to get a list of file names in folders on Windows and save them to a table, by run SQL in Management Studio.
For that, I need to get a list of file names in folders on Windows, by run SQL in Management Studio.
I know that with "xp_cmdshell", I can make this happen.
However, I believe there are concerns about "xp_cmdshell", it is better not to actively use it on the reason of security risk.
Therefore, I want to know if there is no other way.
I'd appreciate it if someone could tell me how to solve this problem.