I am using xp_cmdshell in one of my stored procedures(database SQL server) to delete older files from a folder
in another server. That server is mapped as a network drive on the sql server computer. But when I used this drive inside xp_cmdshell command and do a dir , the output I get is 'Access is denied'. Then I used the UNC path . The same output I get Access denied. But I can always see the folders both thru the drive or the network from the start menu. Please help.
Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!