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.