I am trying to create a directory dynamically in sql server using xp_create_subdir in my stored procedure.
In trying to create dir in network path in \\10.20.33.883\d$ewfolders. Since the network path is not enabled using xp_cmdshell and my sp throws below error
Xp_create_subdir() return error 161.the specified path is invalid
I need to capture the error and printed in results tab.
Please do the needful. thanks in advance.